Night Owl 6

home *** CD-ROM | disk | FTP | other *** search

/ Night Owl 6 / Night Owl's Shareware - PDSI-006 - Night Owl Corp (1990).iso / 050a / dayo1_9.zip / DAYOGL.DOC

Wrap

Text File | 1991-02-17 | 392KB | 6,696 lines

╔════════════════════════════════════════════════════════════════════════════╗ ║ ║ ║ █▄██████████▒░ █████▒░ ██▒░ ██░ ███████████▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ █▒░ █▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░██░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ███▀▀▀▀▀███▒░ ████▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ ███▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ██▒░ ║ ║ █▀██████████▒░ ██▒░ ██▒░ ██▒░ ███████████▒░ ║ ║ ░░░░░░░░░░░ ░░░ ░░░ ░░░ ░░░░░░░░░░░░ ║ ║ ║ ║ ║ ║ ║ ║ ▄████░ ████░ █░ █░ ████░ █▄██▄ ▄█▄ ▀█░ ║ ║ █░ █░ ██░ █░ █░ █░ █░ █░█░ █░ ║ ║ █░ ███░ ███░█░ ███░ █░ █░ █░█░ █░ ║ ║ █░█▀█░ █░ █░███░ █░ █▄▄█▀ ▄███▄ █░ ║ ║ █░ █░ █░ █░ ██░ █░ █▀█▄▄ █░ █░ █░ ║ ║ ▀███▀ ████░ █░ █░ ████░ █░ █░ █░ █░ ████░ ║ ║ ║ ║ ║ ║ ▀█░ ████░ █▄██▄ ▄████░ ████░ █▄██▄ ║ ║ █░ █░ █░ █░ █░ █░ █░ █░ ║ ║ █░ ███░ █░ █░ █░ ███░ █░ █░ ║ ║ █░ █░ █░ █░ █░█▀█░ █░ █▄▄█▀ ║ ║ █░ █░ █░ █░ █░ █░ █░ █▀█▄▄ ║ ║ ████░ ████░ █▀██▀ ▀███▀ ████░ █░ █░ ║ ║ ║ ║ ║ ║ GENERAL LEDGER FOR THE DAYO MODULES ║ ║ ║ ║ Copyright (c) 1990, TJS LAB, PO Box 585366, Orlando, Florida 32858 ║ ║ ║ ║ ▓▓▓▓▓▓ ███████████▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▄▐█▌ ║ ║ ▀ ▓▓ ▀ ▓▓▓▓ ▀▀▀▀▀███████████████████████████▌ S ║ ║ ▓▓ ▓▓ ▄▓▓▓▄ ▀████▀▀ ▀████████████ O ║ ║ ▓▓ ▓▓ ▓▓ ▀▀ ███████████ F ║ ║ ▓▓ ▓▓ ▓▓ ▀▓▓▓▄ Specializing In ▐█████████▌ T ║ ║ ▀▓▓▓▀ ▓▓ MicroComputer ██████████ C W ║ ║ ▀▓▓▓▀ & LAN █████■████▌ O A ║ ║ Applications ▐███████████ N R ║ ║ ┌─┐ ┌─┐ ███████████▌ S E ║ ║ ▀▓▓ ▓ ▀▓▄▓▓▓▄ ┌╧─╧┐ ┌─┐ ┌╧─╧┐ ████▀ ▀███ U ║ ║ ▓▓ ▓▓▓ ▓▓ ▓▓ └───╜ ┌╧─╧┐ └───╜ ███ ██▌ L & ║ ║ ▓▓ ▄▓ ▓▄ ▓▓▓▓▓ ░█░ └───╜ ░█░ ███▄▄███ T ║ ║ ▓▓ ▓▓▓▓▓ ▓▓ ▓▓ █████ ░█░ █████ ▀█████▌ I ║ ║ ▓▓▓▓ ▄▓ ▓▄ ▓▀▓▓▓▀ █████ ▀▀▀█ N ║ ║ █ G ║ ║ PO BOX 585366, ORLANDO, FLORIDA 32858 ▄▄▄▄▀ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO GL, TJS LAB Orlando, Florida "Try before you buy..." ┌─────────┐ ┌─────┴───┐ │ (tm) ──│ │o │────────────────── │ ┌─────┴╨──┐ │ Association of │ │ │─┘ Shareware └───│ o │ Professionals ──────│ ║ │──────────────────── └────╨────┘ MEMBER This program is produced by a member of the Association of Shareware Professionals (ASP). ASP wants to make sure that the shareware principle works for you. If you are unable to resolve a shareware-related problem with an ASP member by contacting the member directly, ASP may be able to help. The ASP Ombudsman can help you resolve a dispute or problem with an ASP member, but does not provide technical support for members' products. Please write to the ASP Ombudsman at P.O. Box 5786, Bellevue, WA 98006 or send a Compuserve message via easyplex to ASP Ombudsman 70007,3536 ■ SOFTWARE SUPPORT POLICY 1. TJS LAB does not support users of unregistered DAYO products with the exception of installation questions. 2. Support (included with registration) remains in effect for 1 year after date of registration or upgrade. 3. Support is available through the following methods: - Phone/Voice Mail: (407) 291-3960/6987 - U.S. Mail: TJS LAB, PO Box 585366, Orlando, FL 32858-5366 - Compuserve Easyplex: 76367,1401 4. Any errors ("bugs or features') in the program will be corrected and the 'fix' sent promptly (via modem if possible). DAYO GL, TJS LAB Page: 1 Table of Contents Page Subject ──── ─────────────────────────────────────── 5 ............... INTRODUCTION 7 ............... COPYRIGHT/LICENSE 7 ............... DISCLAIMER 7 ............... REQUIREMENTS 7 ............... SETUP 8 ............... MAIN MENU 8 ............... PASSWORD/NAME 9 ............... BROWSE CHART OF ACCOUNTS - GL.DBF 11 ............... DEFAULT CHART OF ACCOUNTS 14 ............... FULL SCREEN EDIT - GL.DBF - F2 15 ............... BROWSE/VIEW CLASSIFICATIONS (GLCLASS.DBF) - F3 16 ............... BROWSE/VIEW TRANSACTIONS (GLTRANS.DBF) - F4 16 ............... ADD/CREATE NEW GL ACCOUNT - CTRL N 17 ............... RECALCULATE GL ACCOUNTS - ALT F1 17 ............... SELECT ACTIVE PERIOD - CTRL F1 18 ............... FIND - F5,F6,F7 18 ............... BROWSE CLASSIFICATION DATABASE (GLCLASS.DBF) 20 ............... EXAMPLE OF CLASSIFICATION/CLASS CODES 21 ............... BROWSE SCREEN (GLCLASS.DBF) 22 ............... FULL SCREEN EDIT - GLCLASS.DBF - F2 23 ............... ADD/CREATE NEW CLASS CODE - CTRL N 24 ............... BROWSE CHART OF ACCOUNTS DATABASE - GL.DBF - F3 25 ............... BROWSE TRANSACTION DATABASE - GLTRANS.DBF - F4 26 ............... FIND - F5,F6,F7,F8 & F9 27 ............... BROWSE GENERAL LEDGER TRANSACTIONS - GLTRANS.DBF 28 ............... FULL SCREEN EDIT - GLTRANS.DBF - F2 28 ............... CREATE NEW TRANSACTION RECORD - CTRL N 29 ............... BROWSE CHART OF ACCOUNTS DATABASE - GL.DBF - F3 29 ............... BROWSE CLASS CODE DATABASE - GLCLASS.DBF - F4 30 ............... FIND - F5,F6,F7,F8 & F9 31 ............... GENERAL LEDGER POST & EXPORT 32 ............... POST TRANSACTIONS TO CHART OF ACCOUNTS 32 ............... SELECT ACCOUNTING PERIOD 33 ............... SELECT DAYO MODULE(S) TO POST 33 ............... OUTPUT TO PRINTER? 33 ............... ENTER FILE NAME 34 ............... GENERAL LEDGER EXPORT 34 ............... SELECT INDEX 35 ............... SELECT EXPORT FORMAT 35 ............... ENTER CONDITION/FILTER 36 ............... ENTER EXPORT FILE NAME 37 ............... POST NET EARNINGS 38 ............... REPORTS 38 ............... REPORT & ROUTINES LISTING 39 ............... GL RECONCILIATION REPORT DAYO GL, TJS LAB Page: 2 Table of Contents Page Subject ──── ─────────────────────────────────────── 40 ............... TRIAL BALANCE REPORT 42 ............... EXAMPLE OF THE GL TRIAL BALANCE 43 ............... BALANCE SHEET 44 ............... EXAMPLE OF GL BALANCE SHEET REPORT 45 ............... BALANCE SHEET II (YTD) 45 ............... EXAMPLE OF BALANCE SHEET II (YTD) 46 ............... INCOME & EXPENSES REPORT (PROFIT & LOSS) 47 ............... EXAMPLE OF THE GL INCOME & EXPENSES REPORT 48 ............... INCOME & EXPENSES REPORT II (YTD) 48 ............... EXAMPLE OF INCOME & EXPENSES REPORT II 49 ............... ASSETS REPORT 49 ............... EXAMPLE OF THE ASSETS REPORT 50 ............... ASSETS REPORT II (YTD) 50 ............... EXAMPLE OF ASSETS REPORT II (YTD) 51 ............... LIABILITY REPORT 52 ............... EXAMPLE OF THE LIABILITY REPORT 53 ............... LIABILITY REPORT II (YTD) 53 ............... EXAMPLE OF LIABILITY REPORT II (YTD) 54 ............... EQUITY REPORT 54 ............... EXAMPLE OF THE GL EQUITY REPORT 55 ............... EQUITY REPORT II (YTD) 55 ............... EXAMPLE OF EQUITY REPORT II (YTD) 56 ............... INCOME REPORT 56 ............... EXAMPLE OF THE INCOME REPORT 57 ............... INCOME REPORT II (YTD) 57 ............... EXAMPLE OF INCOME REPORT II (YTD) 58 ............... COST OF GOODS REPORT 58 ............... EXAMPLE OF THE COST OF GOODS REPORT 59 ............... COST OF GOODS REPORT II (YTD) 59 ............... EXAMPLE OF COST OF GOODS REPORT II (YTD) 60 ............... EXPENSES REPORT 61 ............... EXAMPLE OF THE EXPENSES REPORT 62 ............... EXPENSES REPORT II (YTD) 62 ............... EXAMPLES OF EXPENSES REPORT II 63 ............... TRANSACTION REPORT 64 ............... CHART OF ACCOUNTS REPORT 65 ............... EXAMPLE OF THE CHART OF ACCOUNTS LIST/REPORT 66 ............... PERIODS REPORT 67 ............... EXAMPLE OF THE ACCOUNTING PERIODS LIST/REPORT 67 ............... BUDGETS REPORT 68 ............... CURRENT BUDGET REPORT 69 ............... EXAMPLE OF THE CURRENT BUDGETS REPORT 70 ............... CLASS CODE REPORT 71 ............... PURGE TRANSACTIONS 73 ............... ROLL ACCOUNTING YEAR 76 ............... SAVING THE CHART OF ACCOUNTS 77 ............... GRAPH - BUDGET SUMMARY 78 ............... EXAMPLE OF THE BUDGETS SUMMARY GRAPH REPORT 79 ............... GRAPH - BUDGET DETAIL 80 ............... EXAMPLE OF THE BUDGETS DETAIL GRAPH REPORT DAYO GL, TJS LAB Page: 3 Table of Contents Page Subject ──── ─────────────────────────────────────── 81 ............... FINANCIAL STATEMENT 84 ............... EXAMPLE OF A FINANCIAL STATEMENT 85 ............... EXAMPLE OF A DEPARTMENTAL FINANCIAL STATEMENT 86 ............... CONFIGURATION STATUS REPORT 86 ............... EXAMPLE OF THE CONFIGURATION STATUS REPORT 87 ............... VIEW REPORTS ON SCREEN 88 ............... REPORT VIEWING SCREEN 89 .............. PRINTER DRIVER (SETUP) 90 .............. PRINTER DRIVER OPTIONS 90 .............. CHANGE DEFAULT PRINTER 91 .............. FULL SCREEN EDIT - F2 91 .............. PRINTER DRIVER DATABASE FIELD DEFINITIONS 92 ............... CONFIGURATION 92 ............... CONFIGURATION LISTING 93 ............... COMPANY NAME, ADDRESS & TELEPHONE 93 ............... ACCOUNT BUDGETS 93 ............... INVENTORY LOCATION/DIRECTORY 94 ............... POINT OF SALE (POS) DATABASES LOCATION 94 ............... BACKORDERS DATABASE LOCATION/DIRECTORY 94 ............... CUSTOMER (AR) DATABASE LOCATION/DIRECTORY 95 ............... ACCOUNTS PAYABLE (AP) DATABASE LOCATION 95 ............... PAYROLL DATABASE LOCATION/DIRECTORY 95 ............... ASSETS DATABASE LOCATION/DIRECTORY 96 ............... MATERIALS REQUIREMENT PLANNING (MRP) LOCATION 96 ............... END OF PERIOD - PHYSICAL INVENTORY LOCATION 96 ............... LAST GL POSTING TRANSACTION NUMBER 97 ............... SAVE PURGED TRANSACTIONS 97 ............... VIEW CHART OF ACCOUNTS 97 ............... STOP GL POSTING AT WRONG CLASS CODE 98 ............... DEPARTMENT CODE SETUP 98 ............... REPORT PRINTER TYPE 98 ............... REPORT PRINTER PORT 99 ............... VISUAL INDEXING 99 ............... AUTOMATIC DAILY INDEXING 99 ............... COLOR MONITOR 99 ............... COLOR INTENSITY 100 ............... MISCELLANEOUS ROUTINES 100 ............... MISC ROUTINES MENU 101 ............... APPEND FROM 103 ............... BROWSE DATABASES 105 ............... COPY (.DBF) TO 107 ............... CREATE DATABASE 109 ............... DELETE RECORDS 110 ............... ERASE FILE 110 ............... EXIT TO DOS 111 ............... INDEX A DATABASE 112 ............... LIST FIELDS 115 ............... MODIFY DATABASE 116 ............... PACK DATABASE DAYO GL, TJS LAB Page: 4 Table of Contents Page Subject ──── ─────────────────────────────────────── 117 ............... RECALL RECORDS 117 ............... RETURN TO MENU 117 ............... RUN (DOS COMMAND) 118 ............... SIMPLE EDITOR 119 ............... SORT DATABASE 120 ............... TYPE (PRINT) FILE 121 ............... ZAP DATABASE 123 ............... HELP SCREENS 124 .............. EXPANDED HELP 125 .............. USER DEFINED & INPUTTED HELP SCREENS/MESSAGES 126 .............. VIEW DOCUMENTATION ONSCREEN 127 ............... DATABASE STRUCTURE 130 ............... DATA DICTIONARY 132 ............... DAYO GL MAINTENANCE & QUIRKS 133 ............... TJS LAB, CUSTOM CODING DAYO GL, TJS LAB Page: 5 ■ INTRODUCTION DAYO General Ledger (GL) provides the means to sum money received and paid out by your business. All GL accounts are classified as one of 3 key accounts: Assets, Liabilities, & Proprietorship. The process of balancing your GL is based on the fundamental accounting equation of: ASSETS = LIABILITIES + PROPRIETORSHIP DAYO General Ledger combines all your DAYO ledgers (ie: Accounts Receivable, Accounts Payable) and others (ie: Payroll, Assets) to create a system of recording and reporting all financial transactions. DAYO GL is a double entry system, requiring a Credit and Debit posting of each and every transaction. Transaction records are computer generated from DAYO modules (ie: AR, AP), but you can manually add transactions via a 'manual means'. DAYO account numbers (GL Entries) are 12 digits in width and in the format: 00000-000000. Each GL Entry is broken down by Major Account, Department, and Sub Account. 10100-100000 Major Account ───┴┘│││ ││││││ Department ────────┴┴┘ └┴┴┴┴┴──── Sub Account DAYO GL comes with a default Chart of Accounts (102 entries), but there is no limit to the number of accounts or how they are posted to. A general rule of numbering exists for the Major Accounts though. Major Accounts are designated by the first two digits, and the following are (by default) reserved: a. All Accounts starting with '1' are Assets b. All Accounts starting with '2' are Liabilities c. All Accounts starting with '3' are Equity Accounts d. All Accounts starting with '4' are Income Accounts e. All Accounts starting with '5' are Cost of Sales f. All Accounts starting with '7' or '9' are Expenses & Taxes Any number of accounting periods are supported, however 12 is the default. Transactions are posted to the Chart of Accounts based on Class Codes and the date of the transaction. Class Codes are comprised of a 3 digit field found in every DAYO database. Transactions all have a date field (DATE). Accurate Class Codes are essential to DAYO GL. DAYO GL, TJS LAB Page: 6 Some of the DAYO GL highlights are: Multiuser (ie: Novell) Data Entry Validation Databases are dBase (tm) compatible Double Entry Computer Generated Posting Export Data to Other Formats Conditional Posting Unlimited Accounts Unlimited Periods Budgets 20+ Configuration Settings Passwords (with DAYO Passwords) 30+ Reports & Special Routines Trail Balance Chart of Accounts Balance Sheet Periods Income & Expense Budgets Assets Accounts Budgets Current Liabilities Accounts CLASS Expanded Equity Accounts Purge Transactions Income/Sales Accounts Roll Year Cost of Sales/Goods Graph Budget Summary Expenses Graph Budget Detail Transactions Configuration Settings Other DAYO Products: DAYO Inventory Inventory Control, Vendors, Purchasing, Receiving DAYO POS Point of Sales Billing & Invoicing DAYO Quotes Sales Quoting System DAYO Price Books Special pricing for your customers as well as a wide range of product catalogs/reports DAYO AR Accounts Receivable DAYO AP Accounts Payable DAYO BO Back Orders DAYO EOP End of Period Purge & Physical Inventory DAYO MRP Materials Requirement Planning for Manufacturers DAYO Passwords Password protect your DAYO system DAYOX Network/LAN Index Maintenance Utility DAYO Smart Reports A variety of reports pertaining to the above modules DAYO GL, TJS LAB Page: 7 ■ COPYRIGHT/LICENSE This manual and software is copyrighted with all rights reserved by TJS LAB. No copying of this manual or software is authorized without the prior written consent of TJS LAB. An exception to this rule is the making of backup copies of registered software disks. No RESALE of any part of the source codes is authorized without the prior written consent of TJS LAB. TJS LAB retains all rights to DAYO GL software, documentation, and source codes. Read the Order Form (last page), for more information on Source Codes... Authorization to distribute the Shareware Version (unregistered) is granted. ■ DISCLAIMER No warrant is made that this software will work in all environments, or with all resident programs and hardware configurations. TJS LAB has tested this software in many environments and found it to perform as expected, however, this software is licensed "AS IS". TJS LAB will not be liable for any damage done to your data, hardware, and/or software systems as a result of using DAYO GL. ■ REQUIREMENTS *** IBM or Compatible CPU 640K memory * DOS 3.3 or above Hard Disk ■ SETUP To setup DAYO GL, copy the contents of the DAYO GL floppy disk into a directory on your hard disk (ie: \DAYOGL). If this is the Shareware Version, you need to UnZip/UnArc the files here. When running DAYO GL for the first time, it will create all the database, index, and configuration files it requires for operation. If you are using other DAYO modules, be sure to enter the location of these databases into the DAYO GL configuration. Type and enter 'DAYOG' at the DOS prompt to run the program (ie: C:\DAYOGL\DAYOG ). *** Your CONFIG.SYS file must have the buffers set to a minimum of 10, and your files must have a MINIMUM setting of 55! Failure to edit the CONFIG.SYS file is the #1 cause for DAYO installation problems! A CONFIG.SYS file is created if there is a problem detected, in the directory that this DAYO module is being run in. You may copy this file into your root/boot drive. Refer to your DOS manual for more information on the CONFIG.SYS file! DAYO GL, TJS LAB Page: 8 ■ MAIN MENU After a few moments and possibly a reindex, the main menu will appear (the left side of the screen is the actual main menu): DAYO GL Version 2.0 TJS LAB ┌───[February 1991]──┐ ╓──────────────────────╖ │S M T W T F S │ ║ 1 ACCOUNTS ║ █▄██▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ╟──────────────────────╢ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2│ ║ 2 CLASSIFICATION ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 3 4 5 6 7 8 9│ ╟──────────────────────╢ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │10 11 12 13 14 15 16│ ║ 3 TRANSACTIONS ║ █░ █░ █░ █░ █░ █░ █░ │17 18 19 20 21 22 23│ ╟──────────────────────╢ █▀██▀ █░ █░ █░ ▀███▀ │24 25 26 27 28 │ ║ 4 POST & EXPORT ║ │ │ ╟──────────────────────╢ Copyright (c) 1990-1991 └────────────────────┘ ║ 5 REPORTS ║ ╟──────────────────────╢ ▄████░ ████░ █░ █░ ████░ █▄██▄ ▄█▄ ▀█░ ║ 6 CONFIGURATION ║ █░ █░ ██░ █░ █░ █░ █░ █░█░ █░ ╟──────────────────────╢ █░ ███░ ███░█░ ███░ █░ █░ █░█░ █░ ║ 7 MISC ROUTINES ║ █░█▀█░ █░ █░███░ █░ █▄▄█▀ ▄███▄ █░ ╟──────────────────────╢ █░ █░ █░ █░ ██░ █░ █▀█▄▄ █░ █░ █░ ║ 8 EXIT ║ ▀███▀ ████░ █░ █░ ████░ █░ █░ █░ █░ ████░ ╚══════════════════════╝ ╓──────────────────────────────╖ ▀█░ ████░ █▄██▄ ▄████░ ████░ █▄██▄ ║Database # Records Size║ █░ █░ █░ █░ █░ █░ █░ █░ ║GL 224 93538║ █░ ███░ █░ █░ █░ ███░ █░ █░ ║GLCLASS 0 323║ █░ █░ █░ █░ █░█▀█░ █░ █▄▄█▀ ║GLTRANS 9 1191║ █░ █░ █░ █░ █░ █░ █░ █▀█▄▄ ╚══════════════════════════════╝ ████░ ████░ █▀██▀ ▀███▀ ████░ █░ █░ Chart of Accounts, Sub-Accounts, Departments Note the window displaying the key GL databases at the lower right of the screen. The database to watch is GLTRANS.DBF. This database contains records for every transaction or posting to the Chart of Accounts (GL.DBF). As this database grows, so does the time it takes to index it. The amount of required disk space increases too. To run a menu option, just highlight the option using the arrow keys, then press enter/return. ■ PASSWORD/NAME From the main menu you can enter any of the routines/options, but not until you enter your name (or password if using DAYO Passwords): ┌────────────────────────────────────────────────────────────────────────────┐ │┌──────────────────────────────────────────────────────────────────────────┐│ ││ Enter Your Name: George Moonilal ││ │└──────────────────────────────────────────────────────────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 9 ■ BROWSE CHART OF ACCOUNTS - GL.DBF Use this option to view your Chart of Accounts. By using the arrow keys and the find keys (F5, F6 & F7), you can view any/all your GL Accounts. All options available to you while in this browse are listed on the bottom of the screen. Though not displayed on the bottom of the screen, you can press F1 to view the Help screen for browse options. Note, the option exists to edit the balances in this browse, but it is recommended that you create a transaction for the balance change (it will be automatically updated). This effort creates a good checks and balance system that can be documented with GL Reports. For this browse, 2 displays are possible. The default is the following which displays more than one account onto the screen. The display option can be set/changed in the configuration menu. DAYO GL Version 2.0 TJS LAB Current Period: 6 ╔════════════════[ General Ledger Chart of Accounts - TJS LAB ]══════════════╗ ║Account#: 10000-000000 CURRENT ASSETS Last Date: 07/12/90 ║ ╚════════════════════════════════════════════════════════════════════════════╝ GL_ENTRY NAME PERIOD1 PERIOD2 ─────────────────╥────────────────────────────────╥────────────╥────────────── 10000-000000 ║ CURRENT ASSETS ║ 0.00 ║ 0.00 10000-001010 ║ Petty Cash ║ 4.32 ║ 0.00 10000-001020 ║ Cash-NBSC Checking ║ -9020.09 ║ 0.00 10000-001025 ║ Savings-NBSC ║ 10990.21 ║ 0.00 10000-001030 ║ Returned Checks ║ 0.00 ║ 0.00 10000-001040 ║ Accounts Receivable ║ 12320.00 ║ 0.00 10000-001045 ║ Allow. for Bad Debt ║ 0.00 ║ 0.00 10000-001060 ║ Misc. Receivables ║ -123.67 ║ 0.00 10000-001070 ║ Suspense ║ 0.00 ║ 0.00 10000-001080 ║ Filter Inventory ║ 649985.19 ║ 0.00 10000-001090 ║ Prepaid Insurance ║ 0.00 ║ 0.00 10000-001095 ║ Prepaid Taxes State ║ 0.00 ║ 0.00 10000-001096 ║ Prepaid Taxes Federal ║ 0.00 ║ 0.00 11000-000000 ║ FIXED ASSETS ║ 0.00 ║ 0.00 ─────────────────╨────────────────────────────────╨────────────╨────────────── Esc (Exit) F2 (Edit) F3 (Classes) F4 (Transactions) Ctrl N (Add) Alt F1 (Recalculate Period) Ctrl F1 (Change Period) Find F5 (Account) F6 (Name) F7 (Sub-Account) DAYO GL, TJS LAB Page: 10 The other display consists of most of the data fields for the currently selected GL Account. The first 12 Accounting Periods are display with their corresponding balances, budgets and variances. The date this account was last posted to is displayed at the upper right of the screen. All fields can by seen by using the left and right arrow keys (to sideways scroll a record). DAYO GL Version 2.0 TJS LAB Current Period: 5 ╔═══════════════[ General Ledger Chart of Accounts - TJS LAB ]═══════════════╗ ║Account#: 11002-000000 Checking Account #3 Last Date: 10/09/88 ║ ║ Name From To Amount Budget Variance ║ ║Period 1 January (01/01/90 01/31/90) 0.00 0.00 0.00 ║ ║Period 2 February (02/01/90 02/28/90) 0.00 0.00 0.00 ║ ║Period 3 March (03/01/90 03/31/90) 0.00 0.00 0.00 ║ ║Period 4 April (04/01/90 04/30/90) 0.00 0.00 0.00 ║ ║Period 5 May (05/01/90 05/31/90) 0.00 0.00 0.00 ║ ║Period 6 June (06/01/90 06/30/90) 0.00 0.00 0.00 ║ ║Period 7 July (07/01/90 07/31/90) 0.00 0.00 0.00 ║ ║Period 8 August (08/01/90 08/31/90) 0.00 0.00 0.00 ║ ║Period 9 September (09/01/90 09/30/90) 0.00 0.00 0.00 ║ ║Period 10 October (10/01/90 10/31/90) 0.00 0.00 0.00 ║ ║Period 11 November (11/01/90 11/30/90) 0.00 0.00 0.00 ║ ║Period 12 December (12/01/90 12/31/90) 0.00 0.00 0.00 ║ ╚════════════════════════════════════════════════════════════════════════════╝ GL_ENTRY NAME PERIOD1 PERIOD2 ─────────────────╥────────────────────────────────╥────────────╥────────────── 11003-000000 ║ Checking Account #3 ║ 0.00 ║ 0.00 ─────────────────╨────────────────────────────────╨────────────╨────────────── Esc (Exit) F2 (Edit) F3 (Classes) F4 (Transactions) Ctrl N (Add) Alt F1 (Recalculate Period) Ctrl F1 (Change Period) Find F5 (Account) F6 (Name) F7 (Sub-Account) 3/102 DAYO GL, TJS LAB Page: 11 ■ DEFAULT CHART OF ACCOUNTS DAYO GL comes (by default) with 102 Accounts. How you want to record your finances will determine the changes you wish to make to them (ie: add, delete, modify). GL Entry Name Debits Credits ------------ --------------------------- ------ ------- 10000-000000 CURRENT ASSETS + - 11001-000000 Checking Account #1 + - 11002-000000 Checking Account #2 + - 11003-000000 Accounts Receivable + - 11004-000000 Inventory + - 11005-000000 Inventory Adjustment + - 12000-000000 FIXED ASSETS + - 12001-000000 Equipment + - 12002-000000 Furniture + - 12003-000000 Depreciation Equipment + - 12004-000000 Vehicles + - 12005-000000 Depreciation Vehicles + - 12006-000000 Buildings + - 12007-000000 Depreciation Buildings + - 12008-000000 Land + - 12009-000000 Deposits + - 12010-000000 Prepaid Rent + - 12011-000000 Prepaid Insurance + - 20000-000000 LIABILITIES - + 20001-000000 Accounts Payable - + 20002-000000 Interest Payable - + 20003-000000 Salaries Payable - + 20004-000000 Commissions Payable - + 20105-000000 Payroll Taxes Payable FICA - + 20106-000000 Payroll Taxes Payable SUTA - + 20107-000000 Payroll Taxes Payable FUTA - + 20108-000000 Employee Tax Payable Fed - + 20109-000000 Employee Tax Payable FICA - + 20110-000000 Employee Tax Payable SDI - + 20111-000000 Federal Income Tax - + 20112-000000 State Income Tax - + 20113-000000 Sales Tax Payable - + 20114-000000 Misc Taxes Payable - + 20115-000000 Employee Deduction #1 - + 20116-000000 Employee Deduction #2 - + 20117-000000 Employee Deduction #3 - + 20118-000000 Employee Deduction #4 - + 20119-000000 Employee Deduction #5 - + 20120-000000 Employee Deduction #6 - + 20121-000000 Employee Deduction #7 - + 20122-000000 Employee Deduction #8 - + 21001-000000 Notes Payable - + 21002-000000 Warranties - + DAYO GL, TJS LAB Page: 12 Default Chart of Accounts Continued... 30000-000000 EQUITY - + 30001-000000 Capital Stock - + 30002-000000 Current Year Net Income - + 30003-000000 Previous Retained Earnings - + 30004-000000 Dividend - + 30005-000000 Drawing - + 40000-000000 INCOME, SALES - + 40001-000000 SALES - + 40002-000000 Returns & Refunds - + 50000-000000 COST OF SALES/GOODS + - 50001-000000 Beginning Inventory + - 50002-000000 Ending Inventory + - 50003-000000 Purchases + - 50004-000000 Inventory Adjustments + - 50005-000000 Freight + - 50006-000000 Vendor Returns + - 70000-000000 EXPENSES + - 70001-000000 Advertising + - 71000-000000 EXPENSES, TAXES + - 71001-000000 Bank Charges + - 71002-000000 Depreciation Office + - 71003-000000 Depreciation Vehicles + - 71004-000000 Depreciation Building + - 71005-000000 Depreciation Other + - 71006-000000 Dues & Subscriptions + - 71007-000000 Equipment Leases & Rentals + - 71008-000000 Insurance + - 71009-000000 Interest + - 71010-000000 Licenses & Fees + - 71011-000000 Bad Checks + - 71012-000000 Miscellaneous + - 71013-000000 Office Supplies + - 71014-000000 Postage + - 71015-000000 Rent + - 71016-000000 Repairs & Maintenance + - 71017-000000 Salaries + - 71018-000000 Commissions + - 71019-000000 Hourly Rate Wages + - 71020-000000 Piecework Wages + - 71021-000000 Sick Pay Wages + - 71022-000000 Vacation Pay Wages + - 71023-000000 Holiday Pay Wages + - 71024-000000 Personal Pay Wages + - 71025-000000 Other Income Wages + - 71026-000000 Contract Labor + - 71027-000000 Consultants + - 71028-000000 Telephone + - 71029-000000 Employee Insurance + - 71030-000000 Credit Card Expense + - DAYO GL, TJS LAB Page: 13 Default Chart of Accounts Continued... 71031-000000 Show & Demonstration Expense + - 90000-000000 Tax Expense + - 90001-000000 SUTA + - 90002-000000 FUTA + - 90003-000000 SDI + - 90004-000000 FICA + - 90005-000000 State Income Tax + - 90006-000000 Federal Income Tax + - 90007-000000 Sales Tax + - 90008-000000 Other Tax + - DAYO GL, TJS LAB Page: 14 ■ FULL SCREEN EDIT - GL.DBF - F2 Press F2 to bring up a screen full of fields that you can then edit. Note, only the first 42 fields are displayed onto the screen. If you add more fields to the database GL.DBF, be sure to put the most frequently edited ones first... DAYO GL Version 2.0 TJS LAB Current Period: 5 ┌────────────────────────[ FULL SCREEN EDIT - GL.DBF ]───────────────────────┐ │ GL_ENTRY: 11002-000000 BUDGET7: 34500.00 │ │ NAME: Checking Account #2 BUDGET8: 35000.00 │ │ PERIOD1: 26845.06 BUDGET9: 35000.00 │ │ PERIOD2: 16460.50 BUDGET10: 30000.00 │ │ PERIOD3: 35660.78 BUDGET11: 25000.00 │ │ PERIOD4: 23460.76 BUDGET12: 25000.00 │ │ PERIOD5: 12345.60 BUDGET13: 0.00 │ │ PERIOD6: 0.00 DR: + │ │ PERIOD7: 0.00 CR: - │ │ PERIOD8: 0.00 DATE: 03/04/90 │ │ PERIOD9: 0.00 LASTDATE: 05/12/90 │ │ PERIOD10: 0.00 │ │ PERIOD11: 0.00 │ │ PERIOD12: 0.00 │ │ PERIOD13: 0.00 │ │ BUDGET1: 25000.00 │ │ BUDGET2: 18000.00 │ │ BUDGET3: 33500.00 │ │ BUDGET4: 22000.00 │ │ BUDGET5: 20500.00 │ │ BUDGET6: 30500.00 │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO GL, TJS LAB Page: 15 ■ BROWSE/VIEW CLASSIFICATIONS (GLCLASS.DBF) - F3 Should the need or desire exist to view the Classifications database GLCLASS.DBF (which contains the Class Code definitions), press F3. The lower half of the screen will consist of a browse only routine. Use the arrow keys and the find keys (F5, F6, F7, F8 & F9) to view these records. No editing of these records is allowed in this browse only option... DAYO GL Version 2.0 TJS LAB Current Period: 5 ┌───────────────[ BROWSE CLASSIFICATION DATABASE - GLCLASS.DBF ]─────────────┐ │ CLASS NAME DEBIT CREDIT │ │───────────╥────────────────────────────────╥──────────────╥────────────────│ │ APH ║ Desc: APH, TAXES ║ 10000-000000 ║ 40000-000000 │ │ REC ║ Desc: RECEIPTS, AMOUNT ║ 50000-000000 ║ 70000-000000 │ │ XXX ║ Desc: ARH, TAXES ║ 10000-000000 ║ 11000-000000 │ │ XXX ║ Desc: ARH, FREIGHT ║ 10000-000000 ║ 12300-000000 │ │ XXX ║ Desc: ARH, PAID ║ 10000-000000 ║ 11000-000000 │ │ YYY ║ Desc: ARH, TAXES ║ 10000-000000 ║ 11000-000000 │ │ I ║ Desc: ARD, QTY*COST ║ 30000-000000 ║ 11000-000000 │ │ M ║ Desc: ARD, QTY*PRICE ║ 20000-000000 ║ 30000-000000 │ │ ║ ║ ║ │ │ ║ ║ ║ │ │ ║ ║ ║ │ Esc (Exit) Find F5 (Class) F6 (Debit) F7 (Credit) F8 (Name) F9 (Database) 9/10 DAYO GL, TJS LAB Page: 16 ■ BROWSE/VIEW TRANSACTIONS (GLTRANS.DBF) - F4 The viewing of the Transactions database GLTRANS.DBF can be accomplished by pressing F4. Like the Classifications option the lower half of the screen will consist of a browse only routine. Use the arrow keys and the find keys (F5, F6, F7, F8 & F9) to view these records. No editing of these records is allowed in this browse only option... DAYO GL Version 2.0 TJS LAB Current Period: 5 ┌────────────────[ BROWSE TRANSACTION DATABASE - GLTRANS.DBF ]───────────────┐ │ TRANSACT CLASS NAME DEBIT │ │──────────────────╥───────╥────────────────────────────────╥────────────────│ │ 900527000108 ║ XXX ║ AR HEADER 23494 ║ 30102-102930 │ │ 900527000109 ║ XXX ║ AR HEADER 23496 ║ 30102-102930 │ │ 900527000110 ║ XXX ║ AR HEADER 23497 ║ 30102-102930 │ │ 900527000111 ║ XXX ║ AR HEADER 23498 ║ 30102-102930 │ │ 900527000112 ║ XXX ║ AR HEADER 23499 ║ 30102-102930 │ │ 900527000113 ║ XXX ║ AR HEADER 23500 ║ 30102-102930 │ │ 900527000114 ║ XXX ║ AR HEADER 23502 ║ 30102-102930 │ │ 900527000115 ║ XXX ║ AR HEADER 23503 ║ 30102-102930 │ │ 900527000116 ║ XXX ║ AR HEADER 23504 ║ 30102-102930 │ │ 900527000117 ║ XXX ║ AR HEADER 23505 ║ 30102-102930 │ │ 900527000118 ║ XXX ║ AR HEADER 23506 ║ 30102-102930 │ │ 900527000119 ║ XXX ║ AR HEADER 23507 ║ 30102-102930 │ │ 900527000120 ║ XXX ║ AR HEADER 23508 ║ 30102-102930 │ │ 900527000121 ║ XXX ║ AR HEADER 23509 ║ 30102-102930 │ │ 900527000122 ║ XXX ║ AR HEADER 23601 ║ 30102-102930 │ │ 900527000123 ║ XXX ║ AR HEADER 23602 ║ 30102-102930 │ │ 900527000124 ║ XXX ║ AR HEADER 23603 ║ 30102-102930 │ │ 900527000125 ║ XXX ║ AR HEADER 23604 ║ 30102-102930 │ Esc (Exit) Find F5 (Transact) F6 (Class) F7 (Name) F8 (Debit) F9 (Credit) 108/2007 ■ ADD/CREATE NEW GL ACCOUNT - CTRL N To create a new GL Account simultaneously press Ctrl N. Keep in mind that you can edit (overwrite) all unwanted existing accounts before you start adding any more. A window will appear prompting for the new GL Account number and the name/description of it. The number must be in a valid format, and not already in the Chart of Account (GL.DBF). ╔═════════════[ Add/Create New General Ledger Account ]═════════════╗ ║ ║ ║ Enter General Ledger Account Number: 12300-000000 ║ ║ ║ ║ Enter Account Name: Sample Account Number #3 ║ ║ ║ ╚═══════════════════════════════════════════════════════════════════╝ DAYO GL, TJS LAB Page: 17 ■ RECALCULATE GL ACCOUNTS - ALT F1 Should the integrity of balances be in question, you have the option to recalculate the balances by reposting all transactions for a selected period to the Chart of Accounts (GL.DBF). Press Alt F1 simultaneously to perform this task. The amount of time this operation takes depends mainly on the number of transactions you have in the database GLTRANS.DBF. ┌────────────────────────────────────────────────────────────────────────────┐ │This routine will zero out, then recalculate all GL Accounts (in a selected │ │Period). The data is derived from the transactions (records) in the database│ │GLTRANS.DBF. │ │ │ │Do you wish to continue? (Y/N) │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ SELECT ACTIVE PERIOD - CTRL F1 The current period is selected by pressing Ctrl F1. The selection of the correct Accounting Period is imperative before running Recalculate option. The selection of Current Period is not temporary, so be sure to leave the Period selection accurately set before exiting this browse routine. ┌────────────────────────────────────────────────────────────────────────────┐ │ Use this routine to select the active Accounting Period. │ │ │ │ Last GL Post was on 07/05/90 Current Period is 7 │ │ │ │ Select Period -> May 1990 05/01/90 to 05/31/90 │ │ June 1990 06/01/90 to 06/30/90 │ │ July 1990 07/01/90 to 07/31/90 │ │ August 1990 08/01/90 to 08/31/90 │ │ September 1990 09/01/90 to 09/30/90 │ │ October 1990 10/01/90 to 10/31/90 │ │ November 1990 11/01/90 to 11/30/90 │ │ December 1990 12/01/90 to 12/31/90 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 18 ■ FIND - F5,F6,F7 While in the Chart of Accounts browse routine, GL Account records can be located by using one of three find keys: Press F5 to find a GL Account based on the Account Number (GL_ENTRY) ┌─────────────────────────────────────────────────────────────┐ │ Enter GL_ENTRY: 10100-010000 │ └───────────────────────────────────────────────────TJS LAB───┘ Press F6 to find a GL Account based on the Account Name (NAME) ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: Income, Found │ └───────────────────────────────────────────────────TJS LAB───┘ Press F7 to find a GL Account based on the right 6 digits of the Account Number (GL_ENTRY). The right six digits of the GL_ENTRY field denote the GL Sub Account number. Note, it is not necessary to enter in all six digits. ┌─────────────────────────────────────────────────────────────┐ │ Enter RIGHT(GL_ENTRY,6): 100000 │ └───────────────────────────────────────────────────TJS LAB───┘ ■ BROWSE CLASSIFICATION/CROSS REFERENCE DATABASE/TABLE (GLCLASS.DBF) Without a doubt the most complicated aspect of DAYO General Ledger is this Classification process! Because of this fact, we will be verbose and redundant in trying to explain it... Before any computer generated posting can take place, a valid Class Code must exist in the DAYO database to be posted. For example, posting is done from the Accounts Receivable databases ARH.DBF & ARD.DBF. The database ARH.DBF contains the header information, purchase Subtotal, Freight, Taxes and any Adjustment total. The GL Post process will post these fields into the proper GL Account only if the record contains a valid Class Code (CLASS field). Take the Freight for instance. If the Class Code is valid, it will be found in the database GLCLASS.DBF. The GLCLASS record will contain the GL Accounts to be credited and debited with the freight amount. Each field of the database ARH.DBF that gets posted to the Chart of Accounts (GL.DBF) must have a corresponding GLCLASS record telling the GL Post process where to post the amount. DAYO GL, TJS LAB Page: 19 DAYO databases that are currently supported in the computer generated posting process are: ARH.DBF Accounts Receivable Headers Fields: SUBTOTAL, TAXES, FREIGHT, ADJUST, PAID ARD.DBF Accounts Receivable Detail Fields: QTY, PRICE, COST RECEIPTS.DBF Accounts Receivable Cash Receipts Fields: AMOUNT, APPLIED APH.DBF Accounts Payable Headers Fields: SUBTOTAL, TAXES, FREIGHT, ADJUST, AMOUNT APD.DBF Accounts Payable Detail Fields: QTY, COST CHECKS.DBF Checks Paid Fields: AMOUNT DEPOSITS.DBF Bank Deposits Fields: AMOUNT ACCOUNTS.DBF Bank Accounts Fields: BALANCE EXPENSES.DBF Misc Expenses Fields: AMOUNT INVADJ.DBF Inventory Adjustment and Work In Process Fields: QTY, COST, PRICE, RETAIL, DOLLARS ┌────────────────────────────────────────────────────────────────────────┐ │ Not every DAYO GL Account can be computer generated. Currently there │ │ is no DAYO Assets Manager and no DAYO Payroll program. The creation of │ │ an Inventory Value transaction is also required. │ └────────────────────────────────────────────────────────────────────────┘ Many of the fields are redundant, ie: the SUBTOTAL field in the database ARH.DBF is the sum of the QTY * PRICE in the database ARD.DBF. You would probably not want to post both (but you can)... The posting of the database ARD (QTY * PRICE) would be recommended if you want a more detailed Chart of Accounts based on inventory item type, and/or a more detail method of determining the costs of goods. If you are using DAYO MRP, you will probably want to use the Default CLASS Codes supplied and generated by that system when it creates records in the database INVADJ.DBF. DAYO GL, TJS LAB Page: 20 To make Classifications even more customized, a conditional/filter option is available for use (FILTER). This option can be used to further break down posting. For example, you may not want to post records from the database ARD.DBF for CLASS Code 'XXX' if the value of the quantity field (QTY) is less than zero. An entry of 'QTY>0' in the FILTER field will insure that the ARH record will not be posted if the QTY field is less than zero. Data from other than DAYO databases can be posted (contact TJS LAB for more information) if they are dBase (tm) compatible and contain a CLASS, DATE, and TRANSACT field. How and what you post is determined by you. A possible senerio might be as follows: ■ EXAMPLE OF CLASSIFICATION/CLASS CODES Audrey of Gene's Jungle, a distribution center for war supplies, has determined she will post data only from the databases ARH.DBF, APH.DBF, RECEIPTS.DBF, and INVADJ.DBF. The Class Codes (CLASS) in the database ARH.DBF will always be 'ARS' for regular sales and 'ARR' for returns/refunds. The Class Codes in the database APH.DBF will always be 'APS'. The Class Codes in the database RECEIPTS.DBF will always be 'ARS'. The Class Codes in the database INVADJ.DBF will be always be 'ADJ'. Audrey created the default CLASS Code in the DAYO POS, AR, and QUOTES routines. This was accomplished by putting editing the CLASS field for all customers (in the database CUSTOMER.DBF). Audrey edited the CLASS field in the database VENDORS.DBF to create the default CLASS Code for Accounts Payable (DAYO AP) records. The default CLASS Code for the database INVADJ.DBF was accomplished by making all the CLASS fields in the inventory database INV.DBF to be 'ADJ'. * To post the fields in the these databases, Audrey created the following GLCLASS records: Class Debit Credit Code Name/Description Field Database Account Account ───── ─────────────────────── ──────── ──────── ──────────── ──────────── ARS AR Sales, Subtotal SUBTOTAL ARH 00000-000000 00000-000000 ARS AR Sales, Taxes TAXES ARH 00000-000000 00000-000000 ARS AR Sales, Freight FREIGHT ARH 00000-000000 00000-000000 ARS AR Sales, Adjustments ADJUST ARH 00000-000000 00000-000000 ARS AR Sales, Collected PAID ARH 00000-000000 00000-000000 ARR AR Refunds/Returns SUBTOTAL ARH 00000-000000 00000-000000 ARR AR Refunds, Taxes TAXES ARH 00000-000000 00000-000000 ARR AR Refunds, Freight FREIGHT ARH 00000-000000 00000-000000 DAYO GL, TJS LAB Page: 21 Example of GL Class Code Records Continued... Class Debit Credit Code Name/Description Field Database Account Account ───── ─────────────────────── ──────── ──────── ──────────── ──────────── ARR AR Refunds, Adjustments ADJUST ARH 00000-000000 00000-000000 ARR AR Refunds, Paid Back PAID ARH 00000-000000 00000-000000 ARS AR Cash Receipts AMOUNT RECEIPTS 00000-000000 00000-000000 APS AP Subtotal SUBTOTAL APH 00000-000000 00000-000000 ARS AP Taxes TAXES APH 00000-000000 00000-000000 ARS AP Freight FREIGHT APH 00000-000000 00000-000000 ARS AP Adjustments ADJUST APH 00000-000000 00000-000000 ARS AP Paid AMOUNT APH 00000-000000 00000-000000 ADJ Inventory Adjustment QTY*COST INVADJ 00000-000000 00000-000000 All Audrey has to do now to get the computer to generate transaction records and post them to the Chart of Accounts is to run the GL Post routine. ■ BROWSE SCREEN (GLCLASS.DBF) The browse screen display for the General Ledger Classification/Cross Reference database (GLCLASS.DBF) is comprised of the key fields for the currently highlighted record displayed atop the screen, the function keys at the bottom of the screen, and the actual browse of data in the center of the screen. Note, you can access more fields for each record by using the right and left arrow keys. Use the Up, Down, Page Up, Page Down, and find keys to locate and view/edit specific records. Press F1 to view other important keys for a browse routine. DAYO GL, TJS LAB Page: 22 This is a 'working' browse screen, so be careful not to overtype an entry. If you start to, just press Esc once... DAYO GL Version 2.0 TJS LAB ╔══════════════[ General Ledger Classification/Cross Reference ]═════════════╗ ║ CLASS: APH NAME: Desc: APH, TAXES ║ ║ DEBIT: 10000-000000 CREDIT: 40000-000000 ║ ║ DATABASE: APH FIELD: TAXES ║ ║ FILTER: DATE: 05/28/90 ║ ╚════════════════════════════[ Browse GLCLASS.DBF ]══════════════════════════╝ CLASS NAME DEBIT CREDIT ───────────╥────────────────────────────────╥──────────────╥────────────────── APT ║ Desc: APH, TAXES ║ 10000-000000 ║ 40000-000000 REC ║ Desc: RECEIPTS, AMOUNT ║ 50000-000000 ║ 70000-000000 ARA ║ Desc: ARH, AMOUNT ║ 10000-000000 ║ 11000-000000 ART ║ Desc: ARH, TAXES ║ 10000-000000 ║ 11000-000000 ARF ║ Desc: ARH, FREIGHT ║ 10000-000000 ║ 12300-000000 ARP ║ Desc: ARH, PAID ║ 10000-000000 ║ 11000-000000 I ║ Desc: RECEIPTS, AMOUNT ║ 40000-000000 ║ 40000-000000 MRP ║ Desc: INVADJ, COST*QTY ║ 20000-000000 ║ 30000-000000 MRP ║ Desc: INVADJ, COST*QTY ║ 20000-000000 ║ 30000-000000 ║ ║ ║ ───────────╨────────────────────────────────╨──────────────╨────────────────── Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) F3 (Chart of Accounts) F4 (Transactions) Find F5 (Class) F6 (Debit) F7 (Credit) F8 (Name) F9 (Database) ■ FULL SCREEN EDIT - GLCLASS.DBF - F2 To edit all fields on one screen, press F2. Be sure to press PgUp, PgDn, or Enter/Return through all the fields to save your changes (if any). Note, the arrow keys will move the cursor... DAYO GL Version 2.0 TJS LAB ┌──────────────────────[ FULL SCREEN EDIT - GLCLASS.DBF ]────────────────────┐ │ CLASS: APH │ │ NAME: Desc: APH, TAXES │ │ DEBIT: 10000-000000 │ │ CREDIT: 40000-000000 │ │ DATABASE: APH │ │ FIELD: TAXES │ │ GL_FILTER: │ │ GL_LOGICAL: │ │ DATE: 05/28/90 │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit DAYO GL, TJS LAB Page: 23 ■ ADD/CREATE NEW CLASS CODE - CTRL N When you want create/add a new Class Code record, press Ctrl N. The upper display window will become your data entry screen for the new record. The first prompt is for a Valid Class Code. ╔═══════════════════════[ Add/Create New Class Code ]════════════════════════╗ ║ ║ ║ Enter a CLASS Code: XXX ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) If you enter a valid CLASS Code (not empty), the prompts for the remaining fields are displayed. You must enter the name/description for the new CLASS Code. The Debit and Credit account numbers must exists in the Chart of Accounts, but no validation of which ones can be used is performed, so be careful here. The database must be one of the following: ARH, ARD, RECEIPTS, APH, APD, CHECKS, DEPOSITS, ACCOUNTS, EXPENSES, or INVADJ. The FIELD prompt must contain a numeric field that exists in the selected database. ╔═══════════════════════[ Add/Create New Class Code ]════════════════════════╗ ║ Enter a CLASS Code: XXX ║ ║ Name: Desc: APH, FREIGHT ║ ║ Debit Account: 10000-000000 Credit Account: 40000-000000 ║ ║ Database: APH Field: FREIGHT ║ ║ Filter: ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) The use of the FILTER is optional, but if used, must contain a valid dBase (tm) type statement for the selected database. Valid conditional entries for the FILTER prompt might be: 'SUBTOTAL>0', 'QTY*COST', 'COST<>0', 'QTY*PRICE', 'TYPE=CLASS', '.NOT. DELETED()', 'DELETED()'. ╔═══════════════════════[ Add/Create New Class Code ]════════════════════════╗ ║ Enter a CLASS Code: XXX ║ ║ Name: Desc: APH, FREIGHT ║ ║ Debit Account: 10000-000000 Credit Account: 40000-000000 ║ ║ Database: APH Field: FREIGHT ║ ║ Filter: !DELETED() ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) DAYO GL, TJS LAB Page: 24 ■ BROWSE CHART OF ACCOUNTS DATABASE - GL.DBF - F3 You have only to press F3 to view the Chart of Accounts (GL.DBF). DAYO GL Version 2.0 TJS LAB ┌────────────────[ BROWSE CHART OF ACCOUNTS DATABASE - GL.DBF ]──────────────┐ │ GL_ENTRY NAME PERIOD1 PERIOD2 │ │────────────────╥────────────────────────────────╥────────────╥─────────────│ │ 40000-000000 ║ INCOME, SALES ║ 0.00 ║ 0.00 │ │ 40001-000000 ║ SALES ║ 0.00 ║ 0.00 │ │ 40002-000000 ║ Returns & Refunds ║ 0.00 ║ 0.00 │ │ 50000-000000 ║ COST OF SALES/GOODS ║ 0.00 ║ 0.00 │ │ 50001-000000 ║ Beginning Inventory ║ 0.00 ║ 0.00 │ │ 50002-000000 ║ Ending Inventory ║ 0.00 ║ 0.00 │ │ 50003-000000 ║ Purchases ║ 0.00 ║ 0.00 │ │ 50004-000000 ║ Inventory Adjustments ║ 0.00 ║ 0.00 │ │ 50005-000000 ║ Freight ║ 0.00 ║ 0.00 │ │ 50006-000000 ║ Vendor Returns ║ 0.00 ║ 0.00 │ │ 70000-000000 ║ EXPENSES ║ 0.00 ║ 0.00 │ │ 70001-000000 ║ Advertising ║ 0.00 ║ 0.00 │ │ 71000-000000 ║ EXPENSES, TAXES ║ 0.00 ║ 0.00 │ │ 71001-000000 ║ Bank Charges ║ 0.00 ║ 0.00 │ │ 71002-000000 ║ Depreciation Office ║ 0.00 ║ 0.00 │ │ 71003-000000 ║ Depreciation Vehicles ║ 0.00 ║ 0.00 │ │ 71004-000000 ║ Depreciation Building ║ 0.00 ║ 0.00 │ │ 71005-000000 ║ Depreciation Other ║ 0.00 ║ 0.00 │ Esc (Exit) Find F5 (Account) F6 (Name) F7 (Sub-Account) 50/103 DAYO GL, TJS LAB Page: 25 ■ BROWSE TRANSACTION DATABASE - GLTRANS.DBF - F4 Transactions can be viewed by pressing F4. DAYO GL Version 2.0 TJS LAB ┌────────────────[ BROWSE TRANSACTION DATABASE - GLTRANS.DBF ]───────────────┐ │ TRANSACT CLASS NAME DEBIT │ │──────────────────╥───────╥────────────────────────────────╥────────────────│ │ 900602000100 ║ XXX ║ Desc: ARH, FREIGHT ║ 10000-000000 │ │ 900602000101 ║ XXX ║ Desc: ARH, PAID ║ 10000-000000 │ │ 900602000102 ║ XXX ║ Desc: ARH, SUBTOTAL ║ 10000-000000 │ │ 900602000103 ║ XXX ║ Desc: ARH, TAXES ║ 10000-000000 │ │ 900602000104 ║ XXX ║ Desc: ARH, FREIGHT ║ 10000-000000 │ │ 900602000105 ║ XXX ║ Desc: ARH, PAID ║ 10000-000000 │ │ 900602000106 ║ XXX ║ Desc: ARH, SUBTOTAL ║ 10000-000000 │ │ 900602000107 ║ XXX ║ Desc: ARH, TAXES ║ 10000-000000 │ │ 900602000108 ║ XXX ║ Desc: ARH, SUBTOTAL ║ 10000-000000 │ │ 900602000109 ║ XXX ║ Desc: ARH, TAXES ║ 10000-000000 │ │ 900602000110 ║ XXX ║ Desc: ARH, SUBTOTAL ║ 10000-000000 │ │ 900602000111 ║ XXX ║ Desc: ARH, TAXES ║ 10000-000000 │ │ 900602000112 ║ XXX ║ Desc: ARH, SUBTOTAL ║ 10000-000000 │ │ 900602000113 ║ XXX ║ Desc: ARH, TAXES ║ 10000-000000 │ │ 900602000114 ║ XXX ║ Desc: ARH, SUBTOTAL ║ 10000-000000 │ │ 900602000115 ║ XXX ║ Desc: ARH, TAXES ║ 10000-000000 │ │ 900614000116 ║ XXX ║ Desc: ARP, SUBTOTAL ║ 10000-000000 │ Esc (Exit) Find F5 (Transact) F6 (Class) F7 (Name) F8 (Debit) F9 (Credit) 2000/2007 DAYO GL, TJS LAB Page: 26 ■ FIND - F5,F6,F7,F8 & F9 There are 5 indexes for the database GLCLASS.DBF. To find a specific CLASS Code you can use the find keys F5, F6, F7, F8, and F9. Press F5 to find a record based on the CLASS Code: ┌─────────────────────────────────────────────────────────────┐ │ Enter CLASS: XXX │ └───────────────────────────────────────────────────TJS LAB───┘ Press F6 to find a record based on the Debit Account Number: ┌─────────────────────────────────────────────────────────────┐ │ Enter DEBIT: 10100-010000 │ └───────────────────────────────────────────────────TJS LAB───┘ Press F7 to find a record based on the Credit Account Number: ┌─────────────────────────────────────────────────────────────┐ │ Enter CREDIT: 70000-100200 │ └───────────────────────────────────────────────────TJS LAB───┘ Press F8 to find a record based on the CLASS Code Name/Description: ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: AR Taxes Collected │ └───────────────────────────────────────────────────TJS LAB───┘ Press F9 to find a record based on the DATABASE Name: ┌─────────────────────────────────────────────────────────────┐ │ Enter DATABASE: ARD │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO GL, TJS LAB Page: 27 ■ BROWSE GENERAL LEDGER TRANSACTIONS - GLTRANS.DBF The General Ledger Transaction browse routine is the routine you will use to view posted transactions, add new ones, and modify existing ones. The key fields are displayed at the top of the screen. The function keys are displayed at the bottom. The transaction data/fields are displayed in the center of the screen. Use the arrow keys to 'move around' this browse routine. Press F1 (Help) for more information on important keystrokes. DAYO GL Version 2.0 TJS LAB ╔══════════════════[ General Ledger Transactions - TJS LAB ]═════════════════╗ ║ TRANSACTION: 900602000104 ║ ║ CLASS: XXX NAME: Desc: ARH, FREIGHT ║ ║ DEBIT: 10000-000000 CREDIT: 11000-000000 ║ ║ AMOUNT: 0.00 DATE: 06/02/90 ║ ╚════════════════════════════[ Browse GLTRANS.DBF ]══════════════════════════╝ TRANSACT CLASS NAME DEBIT ───────────────────╥───────╥────────────────────────────────╥───────────────── 900602000104 ║ XXX ║ Desc: ARH, FREIGHT ║ 10000-000000 900602000105 ║ XXX ║ Desc: ARH, PAID ║ 10000-000000 900602000106 ║ XXX ║ Desc: ARH, SUBTOTAL ║ 10000-000000 900602000107 ║ XXX ║ Desc: ARH, TAXES ║ 10000-000000 900602000108 ║ XXX ║ Desc: ARH, SUBTOTAL ║ 10000-000000 900602000109 ║ XXX ║ Desc: ARH, TAXES ║ 10000-000000 900602000110 ║ XXX ║ Desc: ARH, SUBTOTAL ║ 10000-000000 900602000111 ║ XXX ║ Desc: ARH, TAXES ║ 10000-000000 900602000112 ║ XXX ║ Desc: ARH, SUBTOTAL ║ 10000-000000 900602000113 ║ XXX ║ Desc: ARH, TAXES ║ 10000-000000 900602000114 ║ XXX ║ Desc: ARH, SUBTOTAL ║ 10000-000000 ──────────────────╨───────╨────────────────────────────────╨───────────────── Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) F3 (Chart of Accounts) F4 (Classes) Find F5 (Transaction) F6 (Class) F6 (Name) F7 (Debit) F8 (Credit) 1994/2007 DAYO GL, TJS LAB Page: 28 ■ FULL SCREEN EDIT - GLTRANS.DBF - F2 If you desire to edit the entire GLTRANS record at once, press F2. DAYO GL Version 2.0 TJS LAB ┌──────────────────────[ FULL SCREEN EDIT - GLTRANS.DBF ]────────────────────┐ │ TRANSACT: 900602000104 │ │ CLASS: XXX │ │ NAME: Desc: ARH, FREIGHT │ │ DEBIT: 10000-000000 │ │ CREDIT: 11000-000000 │ │ AMOUNT: 0.00 │ │ DATE: 06/02/90 │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ CREATE NEW TRANSACTION RECORD - CTRL N To add/create a new transaction record, press Ctrl N. The prompts for the transaction values will appear at the top of the screen. A valid entry in each of the prompts is required before the record can be added to the database GLTRANS.DBF and the amount posted to the Chart of Accounts (GL.DBF). ╔═════════════════════[ Create New Transaction Record ]══════════════════════╗ ║ Transaction: 900614000118 ║ ║ Class: XXX ║ ║ Name: Desc: ARH, FREIGHT ║ ║ Debit Account: 10000-000000 Credit Account: 40000-000000 ║ ║ Amount: 199 . ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) DAYO GL, TJS LAB Page: 29 ■ BROWSE CHART OF ACCOUNTS DATABASE - GL.DBF - F3 If you want to view the Chart of Accounts (GL.DBF), press F3. DAYO GL Version 2.0 TJS LAB ┌────────────────[ BROWSE CHART OF ACCOUNTS DATABASE - GL.DBF ]──────────────┐ │ GL_ENTRY NAME PERIOD1 PERIOD2 │ │────────────────╥────────────────────────────────╥────────────╥─────────────│ │ 71023-000000 ║ Holiday Pay Wages ║ 0.00 ║ 0.00 │ │ 71024-000000 ║ Personal Pay Wages ║ 0.00 ║ 0.00 │ │ 71025-000000 ║ Other Income Wages ║ 0.00 ║ 0.00 │ │ 71026-000000 ║ Contract Labor ║ 0.00 ║ 0.00 │ │ 71027-000000 ║ Consultants ║ 0.00 ║ 0.00 │ │ 71028-000000 ║ Telephone ║ 0.00 ║ 0.00 │ │ 71029-000000 ║ Employee Insurance ║ 0.00 ║ 0.00 │ │ 71030-000000 ║ Credit Card Expense ║ 0.00 ║ 0.00 │ │ 71031-000000 ║ Show & DEMONSTRATION Expense ║ 0.00 ║ 0.00 │ │ 90000-000000 ║ Tax Expense ║ 0.00 ║ 0.00 │ │ 90001-000000 ║ SUTA ║ 0.00 ║ 0.00 │ │ 90002-000000 ║ FUTA ║ 0.00 ║ 0.00 │ │ 90003-000000 ║ SDI ║ 0.00 ║ 0.00 │ │ 90004-000000 ║ FICA ║ 0.00 ║ 0.00 │ │ 90005-000000 ║ State Income Tax ║ 0.00 ║ 0.00 │ │ 90006-000000 ║ Federal Income Tax ║ 0.00 ║ 0.00 │ │ 90007-000000 ║ Sales Tax ║ 0.00 ║ 0.00 │ │ 90008-000000 ║ Other Tax ║ 0.00 ║ 0.00 │ Esc (Exit) Find F5 (Account) F6 (Name) F7 (Sub-Account) 102/103 ■ BROWSE CLASS CODE DATABASE - GLCLASS.DBF - F4 If you want to view the Classifications Database (GLCLASS.DBF), press F4. DAYO GL Version 2.0 TJS LAB ┌─────────────────[ BROWSE CLASS CODE DATABASE - GLCLASS.DBF ]───────────────┐ │ CLASS NAME DEBIT CREDIT │ │───────────╥────────────────────────────────╥──────────────╥────────────────│ │ APH ║ Desc: APH, TAXES ║ 10000-000000 ║ 40000-000000 │ │ REC ║ Desc: RECEIPTS, AMOUNT ║ 50000-000000 ║ 70000-000000 │ │ XXX ║ Desc: ARH, SUBTOTAL ║ 10000-000000 ║ 11000-000000 │ │ XXX ║ Desc: ARH, TAXES ║ 10000-000000 ║ 11000-000000 │ │ XXX ║ Desc: ARH, FREIGHT ║ 10000-000000 ║ 12300-000000 │ │ XXX ║ Desc: ARH, PAID ║ 10000-000000 ║ 11000-000000 │ │ XXX ║ Desc: APH, FREIGHT ║ 10000-000000 ║ 30000-000000 │ │ XXX ║ Desc: APH, FREIGHT ║ 10000-000000 ║ 40000-000000 │ │ YYY ║ Desc: ARH, TAXES ║ 10000-000000 ║ 11000-000000 │ │ ARR ║ Desc: ARD, QTY*COST ║ 30000-000000 ║ 11000-000000 │ │ ARR ║ Desc: ARD, QTY*PRICE ║ 20000-000000 ║ 30000-000000 │ Esc (Exit) Find F5 (Class) F6 (Debit) F7 (Credit) F8 (Name) F9 (Database) 9/12 DAYO GL, TJS LAB Page: 30 ■ FIND - F5,F6,F7,F8 & F9 The transaction database GLTRANS.DBF has 5 indexes. Use the find keys, F5, F6, F7, F8 and F9 to locate specific records. Press F5 to find a transaction based on the transaction number: ┌─────────────────────────────────────────────────────────────┐ │ Enter TRANSACT: 900701012183 │ └───────────────────────────────────────────────────TJS LAB───┘ Press F6 to find a record based on the CLASS Code: ┌─────────────────────────────────────────────────────────────┐ │ Enter CLASS: XXX │ └───────────────────────────────────────────────────TJS LAB───┘ Press F7 to find a record based on the transaction Name/Description: ┌─────────────────────────────────────────────────────────────┐ │ Enter NAME: Desc: TAXES, ARH │ └───────────────────────────────────────────────────TJS LAB───┘ Press F8 to find a record based on the Debit Account Number: ┌─────────────────────────────────────────────────────────────┐ │ Enter DEBIT: 10010-010000 │ └───────────────────────────────────────────────────TJS LAB───┘ Press F9 to find a record based on the Credit Account Number: ┌─────────────────────────────────────────────────────────────┐ │ Enter CREDIT: 31020-100001 │ └───────────────────────────────────────────────────TJS LAB───┘ DAYO GL, TJS LAB Page: 31 ■ GENERAL LEDGER POST & EXPORT DAYO GL Version 2.0 TJS LAB ╔══════════════════════[ General Ledger Post & Export ]══════════════════════╗ ║ ║ ║ ▄██████▄ ▀██░ ▀██▄████▄ ▄█████▄ ▄█████▄ ██████░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ▀ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ▄▄▄ ██░ ██▀█████░ ██░ ██░ ▀█████▄ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ▄██░ ██░ ██░ ██░ ██░ ▄ ██░ ██░ ║ ║ ▀██████░ ██████░ ██░ ▀█████▀ ██████▀ ██░ ║ ║ ║ ║ ║ ║ Select Option ->Post Transactions to Chart of Accounts ║ ║ Export General Ledger data to other formats ║ ║ Post Current Net Profit & Loss ║ ║ Exit ║ ║ ██████░ ██░ ██░ ██▄████▄ ▄█████▄ ██▄███▄ ██████░ ║ ║ ██░ ▀██░ ██▀ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██ ██░ ▀█▄▄█▀ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██████ █████░ ██░ ██▀█████░ ██░ ██░ ██▄▄▄██░ ██░ ║ ║ ██ ██░ ▄█▀▀█▄ ██░ ██░ ██░ ██▀██░ ██░ ║ ║ ██░ ▄██░ ██▄ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██████░ ██░ ██░ ██░ ▀█████▀ ██░ ██░ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) This menu routine contains 3 options, to start the DAYO GL computer generated posting process, an option to export data from the GL database into a different data format (ie: SDF or Delimited), and the option to post net earnings. DAYO GL, TJS LAB Page: 32 ■ POST TRANSACTIONS TO CHART OF ACCOUNTS *** Run the post option only after you have created all the valid CLASS Code records in the database GLCLASS.DBF. DAYO GL Version 2.0 TJS LAB ╔═══════════════════════[ General Ledger Post & Export ]═════════════════════╗ ║ This routine is used to post transactions to your GL Chart of Accounts ║ ║ which is database GL.DBF. This routine can be run as often as is required ║ ║ by your business (ie: once daily, weekly, or monthly). This operation can ║ ║ be lengthy because of the size & number of files it must access/process ║ ║ ie: INVOICE, DETAIL, ARH, ARD, APH, APD, BO, RECEIPTS, EXPENSES, ACCOUNTS, ║ ║ CHECKS, VENDORS, CUSTOMER & SALESPER ║ ║ A detailed post summary/report can be printed. ║ ║ ║ ║ Do you wish to start the GL Post? (Y/N) ║ ║ ║ ║ Are you sure? (Y/N) ║ ║ ║ ║ ▄██████▄ ▀██░ ▀██▄████▄ ▄█████▄ ▄█████▄ ██████░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ▀ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ▄▄▄ ██░ ██▀█████░ ██░ ██░ ▀█████▄ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ▄██░ ██░ ██░ ██░ ██░ ▄ ██░ ██░ ║ ║ ▀██████░ ██████░ ██░ ▀█████▀ ██████▀ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ SELECT ACCOUNTING PERIOD The first GL Posting prompt is to select the current Accounting Period: DAYO GL Version 2.0 TJS LAB ╔══════════════════════[ General Ledger Post & Export ]══════════════════════╗ ║ Last GL Post was on 07/02/90 Current Period is 7 ║ ║ ║ ║ Select Period -> January 1990 01/01/90 to 01/31/90║ ║ February 1990 02/01/90 to 02/28/90║ ║ March 1990 03/01/90 to 03/31/90║ ║ April 1990 04/01/90 to 04/30/90║ ║ May 1990 05/01/90 to 05/31/90║ ║ June 1990 06/01/90 to 06/30/90║ ║ July 1990 07/01/90 to 07/31/90║ ║ August 1990 08/01/90 to 08/31/90║ ║ September 1990 09/01/90 to 09/30/90║ ║ ▄██████▄ ▀██░ ▀██▄████▄ ▄█████▄ ▄█████▄ ██████░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ▀ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ▄▄▄ ██░ ██▀█████░ ██░ ██░ ▀█████▄ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ▄██░ ██░ ██░ ██░ ██░ ▄ ██░ ██░ ║ ║ ▀██████░ ██████░ ██░ ▀█████▀ ██████▀ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO GL, TJS LAB Page: 33 ■ SELECT DAYO MODULE(S) TO POST The next prompt is for the database(s) you wish to post. The valid selections are ALL, Accounts Receivable, Accounts Payable, Inventory Adjustments, Payroll, and Assets. Note, Payroll and Assets are not currently supported in the general release (contact TJS LAB for more information). DAYO GL Version 2.0 TJS LAB ╔══════════════════════[ General Ledger Post & Export ]══════════════════════╗ ║ Last GL Post was on / / Current Period is 7 ║ ║ ║ ║ Select Period -> July 1990 07/01/90 to 07/31/90║ ║ ║ ║ Select DAYO Module(s) to Post -> ALL ║ ║ ACCOUNTS RECEIVABLE ║ ║ ACCOUNTS PAYABLE ║ ║ INVENTORY ADJUSTMENTS ║ ║ PAYROLL ║ ║ ASSETS ║ ║ ║ ║ ║ ║ ║ ║ ▄██████▄ ▀██░ ▀██▄████▄ ▄█████▄ ▄█████▄ ██████░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ▀ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ▄▄▄ ██░ ██▀█████░ ██░ ██░ ▀█████▄ ██░ ║ ║ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██░ ▄██░ ██░ ██░ ██░ ██░ ▄ ██░ ██░ ║ ║ ▀██████░ ██████░ ██░ ▀█████▀ ██████▀ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) ■ OUTPUT TO PRINTER? You have (like almost all DAYO reports) the option to print the detailed posting report to printer or file. Press Y to send the report directly to the printer or N to send it to a file. The prompt will look like: Send Output to Printer? (Y/N) ( No -> To File) ■ ENTER FILE NAME If you selected the option to print the report to a file, a prompt will appear. The default file name for the report will consist of the letters 'GL', the date in the format 'YYMMDD', plus '.TXT'. An example of the prompt is: Enter File Name: GL900615.TXT DAYO GL, TJS LAB Page: 34 ■ GENERAL LEDGER EXPORT Use the General Ledger Export routine to create file formats that can be read by other than DAYO programs like your word processor, Lotus (tm), or another database or reporting system. Data that can be exported comes from the Chart of Accounts (GL.DBF) or the GL transactions (GLTRANS.DBF). The first prompt is to select the database you wish to export from: DAYO GL Version 2.0 TJS LAB ╔══════════════════════[ General Ledger Post & Export ]══════════════════════╗ ║ ║ ║ Select Database -> GL.DBF - General Ledger Chart of Accounts ║ ║ GLTRANS.DBF - General Ledger Transactions ║ ║ Exit ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ██████░ ██░ ██░ ██▄████▄ ▄█████▄ ██▄███▄ ██████░ ║ ║ ██░ ▀██░ ██▀ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██ ██░ ▀█▄▄█▀ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██████ █████░ ██░ ██▀█████░ ██░ ██░ ██▄▄▄██░ ██░ ║ ║ ██ ██░ ▄█▀▀█▄ ██░ ██░ ██░ ██▀██░ ██░ ║ ║ ██░ ▄██░ ██▄ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██████░ ██░ ██░ ██░ ▀█████▀ ██░ ██░ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) ■ SELECT INDEX The next prompt is to select the index you with the data to be in. There are 3 indexes for GL.DBF and 5 for GLTRANS.DBF. Highlight the desired index, then press enter/return. The prompt for database GL.DBF will look like: Select Index -> Account Number Name Sub Account DAYO GL, TJS LAB Page: 35 ■ SELECT EXPORT FORMAT Currently DAYO supports 4 export formats: SDF - Standard Data Format, Delimited with Double Quotes & Commas, Delimited with Single Quotes & Commas, and Delimited with Carat Sign ^. Highlight the desired export format, then press enter/return. DAYO GL Version 2.0 TJS LAB ╔══════════════════════[ General Ledger Post & Export ]══════════════════════╗ ║ ║ ║ Select Database -> GL.DBF - General Ledger Chart of Accounts ║ ║ ║ ║ Select Index -> Account Number ║ ║ ║ ║ Select Export Format -> SDF - Standard Data Format ║ ║ Delimited with Double Quotes & Commas ║ ║ Delimited with Single Quotes & Commas ║ ║ Delimited with Carat Sign ^ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ██████░ ██░ ██░ ██▄████▄ ▄█████▄ ██▄███▄ ██████░ ║ ║ ██░ ▀██░ ██▀ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██ ██░ ▀█▄▄█▀ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██████ █████░ ██░ ██▀█████░ ██░ ██░ ██▄▄▄██░ ██░ ║ ║ ██ ██░ ▄█▀▀█▄ ██░ ██░ ██░ ██▀██░ ██░ ║ ║ ██░ ▄██░ ██▄ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██████░ ██░ ██░ ██░ ▀█████▀ ██░ ██░ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) ■ ENTER CONDITION/FILTER The prompt for the Condition/Filter is optional, but can be used to export only records that meet the condition you enter. The default (blank) is to copy all records from the selected database. A common filter is to include the DATE field, since only records for a certain date range are often required. An example of a valid filter using the DATE field would be DATE>=CTOD("04/01/90") .AND. DATE<CTOD("05/01/90") Note this is a valid dBase (tm) syntax statement, and if you plan on using the filter, you may want to pick up a book on dBase (tm). Oh, the term 'CTOD' is a function to convert a string (the date) into a date type variable... An example of the prompt for the Condition/Filter is: Enter Condition/Filter (Default is ALL): DAYO GL, TJS LAB Page: 36 ■ ENTER EXPORT FILE NAME All exports are sent to a file with the name you supply in this prompt. If you wish, you can also supply the drive/directory with the name. A default name will be created. An example of the prompt for the export file name and the final Export routine screen is: DAYO GL Version 2.0 TJS LAB ╔══════════════════════[ General Ledger Post & Export ]══════════════════════╗ ║ ║ ║ Select Database -> GL.DBF - General Ledger Chart of Accounts ║ ║ ║ ║ Select Index -> Account Number ║ ║ ║ ║ Select Export Format -> SDF - Standard Data Format ║ ║ ║ ║ Enter Condition/Filter (Default is ALL): ║ ║ ║ ║ Enter Export File Name: GLACCT.SDF ║ ║ ║ ║ ║ ║ ║ ║ ██████░ ██░ ██░ ██▄████▄ ▄█████▄ ██▄███▄ ██████░ ║ ║ ██░ ▀██░ ██▀ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██ ██░ ▀█▄▄█▀ ██░ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██████ █████░ ██░ ██▀█████░ ██░ ██░ ██▄▄▄██░ ██░ ║ ║ ██ ██░ ▄█▀▀█▄ ██░ ██░ ██░ ██▀██░ ██░ ║ ║ ██░ ▄██░ ██▄ ██░ ██░ ██░ ██░ ██░ ██░ ║ ║ ██████░ ██░ ██░ ██░ ▀█████▀ ██░ ██░ ██░ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit/Abort) DAYO GL, TJS LAB Page: 37 ■ POST NET EARNINGS ╔════════════════════════════════════════════════════════════════════════════╗ ║This Posting will post your net earnings (Profit or Loss) into GL Account ║ ║Number: (30002-000000) ║ ║Run with Caution! ║ ║ ║ ║Select Period -> January 1990 01/01/90 to 01/31/90 ║ ║ ║ ║Purchases 320.22 ║ ║Inventory Adjustments 2.50 ║ ║Freight 41.29 ║ ║Vendor Returns 2.01 ║ ║EXPENSES 1240.31 ║ ║Advertising 0.00 ║ ║EXPENSES, TAXES 510.00 ║ ║Bank Charges 4.10 ║ ║Depreciation Office 10.40 ║ ║Depreciation Vehicles 0.00 ║ ║Depreciation Building 23.30 ║ ║Depreciation Other 1.10 ║ ║Dues & Subscriptions 5.00 ║ ║Equipment Leases & Rentals 3.56 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Standby, While I compute the Net Earnings... Press Esc to Abort... DAYO GL, TJS LAB Page: 38 ■ REPORTS There are over 30 General Ledger reports and routines in this menu. All print to printer or file. The width of the reports vary by report, but the width is usually displayed onto the screen. Some of the reports are comprised of a dBase (tm) compatible Report Form, which gives you the option (should you possess dBase (tm)) to manipulate the contents and format of the report. Reports default to printing 60 lines per page, but only the Report Forms can be changed. DAYO GL Version 2.0 TJS LAB REPORTS ┌───[February 1991]──┐ ╔═════════════════════════╗ │S M T W T F S │ ║ GL REPORTS ║█▄██▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ╟─────────────────────────╢█░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6│ ║ GL Reconciliation ║█░ █░ █░█░ ▀█░██░ █░ █░ │ 7 8 9 10 11 12 13│ ║ Trial Balance ║█░ █░ █▀▀▀█░ ▀█▀ █░ █░ │14 15 16 17 18 19 20│ ║ Balance Sheet ║█░ █░ █░ █░ █░ █░ █░ │21 22 23 24 25 26 27│ ║ Balance Sheet II ║█▀██▀ █░ █░ █░ ▀███▀ │28 29 30 31 │ ║ Income & Expense ║ │ │ ║ Income & Expense II ║ └────────────────────┘ ║ Assets Accounts ║ ║ Assets Accounts II ║ ▄████░ ████░ █░ █░ ████░ █▄██▄ ▄█▄ ▀█░ ║ Liabilities Accounts ║ █░ █░ ██░ █░ █░ █░ █░ █░█░ █░ ║ Liabilities Accounts II ║ █░ ███░ ███░█░ ███░ █░ █░ █░█░ █░ ║ Equity Accounts ║ █░█▀█░ █░ █░███░ █░ █▄▄█▀ ▄███▄ █░ ║ Equity Accounts II ║ █░ █░ █░ █░ ██░ █░ █▀█▄▄ █░ █░ █░ ║ Income/Sales Accounts ║ ▀███▀ ████░ █░ █░ ████░ █░ █░ █░ █░ ████░ ║ Income/Sales Accts II ║ ║ Cost of Sales/Goods ║────╖ ▀█░ ████░ █▄██▄ ▄████░ ████░ █▄██▄ ║ Cost of Sales/Goods II ║Size║ █░ █░ █░ █░ █░ █░ █░ █░ ║ Expenses ║5121║ █░ ███░ █░ █░ █░ ███░ █░ █░ ╟─────────────────────────╢ 323║ █░ █░ █░ █░ █░█▀█░ █░ █▄▄█▀ ║ Select Option ║ 291║ █░ █░ █░ █░ █░ █░ █░ █▀█▄▄ ╚═════════════════════════╝════╝ ████░ ████░ █▀██▀ ▀███▀ ████░ █░ █░ ■ REPORT & ROUTINES LISTING Reconciliation Expenses Trial Balance Expenses II Balance Sheet Transactions Balance Sheet II Chart of Accounts Income & Expense Periods Income & Expense II Budgets Assets Accounts Budgets Current Assets Accounts II CLASS Expanded Liabilities Accounts Purge Transactions Liabilities Accounts II Roll Year Equity Accounts Graph Budget Summary Equity Accounts II Graph Budget Detail Income/Sales Accounts Configuration Settings Income/Sales Accts II View Reports On Screen Cost of Sales/Goods Printer Setup Cost of Sales/Goods II User Defined Financial Statement DAYO GL, TJS LAB Page: 39 ■ RECONCILIATION REPORT This report will be used to reconcile GL Account balances by printing all transactions that affect each account out for a selected period. Note, you can also print a variation of this report with the TRANSACTION Report. ╔════════════════════════════════════════════════════════════════════════════╗ ║The GL Reconciliation Report lists all transactions that affect each GL ║ ║Account (Debits & Credits) for a selected accounting period. ║ ║Not a Report Form (101 characters wide). ║ ║ ║ ║Select Period -> May 1990 05/01/90 to 05/31/90 ║ ║ ║ ║Enter number of lines per page: 56 ║ ║ ║ ║Print All Transactions? (Y/N) ( No -> Specific Account) ║ ║ ║ ║Enter GL Account Number: 10000-001040 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: RECON.TXT ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Standby, While I print this report... Press Esc to Abort... DAYO GL, TJS LAB Page: 39.1 After selecting the number of lines per page, and whether the report will be directed to the printer or to a file, a progress graph will appear. ╔════════════════════════════════════════════════════════════════════════════╗ ║The GL Reconciliation Report lists all transactions that affect each GL ║ ║Account (Debits & Credits) for a selected accounting period. ║ ║Not a Report Form (101 characters wide). ║ ║ ║ ║Select Period -> February 1990 02/01/90 to 02/28/90 ║ ║ ║ ║ ┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐┌───┐ ║ ║ │10%││20%││30%││40%││50%││60%││ ││ ││ ││ │ ║ ║ └───┘└───┘└───┘└───┘└───┘└───┘└───┘└───┘└───┘└───┘ ║ ║ ║ ║70009-000000 Equipment Leases & Rentals ║ ║70008-000000 Dues & Subscriptions ║ ║70007-000000 Depreciation Other ║ ║70006-000000 Depreciation Building ║ ║70005-000000 Depreciation Vehicles ║ ║70004-000000 Depreciation Office ║ ║70003-000000 Bank Charges ║ ║70002-000000 EXPENSES, TAXES ║ ║70001-000000 Advertising ║ ║70000-000000 EXPENSES ║ ╚════════════════════════════════════════════════════════════════════════════╝ Standby, While I print this report... Press Esc to Abort... DAYO GL, TJS LAB Page: 40 ■ TRIAL BALANCE REPORT The purpose of the Trial Balance report is to simply prove that the debits and credits are equal! The Trial Balance report lists all your General Ledger accounts in a two column report. Balances are displayed in one of the two columns. The theory is that the two columns will 'balance', but if they do not, it does not necessarily mean it is wrong. Like most other GL reports, how and to what accounts you post the transaction to determines what this report will look like. The first prompt is to select the period you want to report on: ╔════════════════════════════════════════════════════════════════════════════╗ ║The Trial Balance Report lists all your General Ledger Accounts (balances ║ ║in two columns). ║ ║Not a Report Form (80 characters wide). ║ ║ ║ ║Select Period -> January 1990 01/01/90 to 01/31/90 ║ ║ February 1990 02/01/90 to 02/28/90 ║ ║ March 1990 03/01/90 to 03/31/90 ║ ║ April 1990 04/01/90 to 04/30/90 ║ ║ May 1990 05/01/90 to 05/31/90 ║ ║ June 1990 06/01/90 to 06/30/90 ║ ║ July 1990 07/01/90 to 07/31/90 ║ ║ August 1990 08/01/90 to 08/31/90 ║ ║ September 1990 09/01/90 to 09/30/90 ║ ║ October 1990 10/01/90 to 10/31/90 ║ ║ November 1990 11/01/90 to 11/30/90 ║ ║ December 1990 12/01/90 to 12/31/90 ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO GL, TJS LAB Page: 41 After selecting the period to report, you are given the options to print year to date (YTD) totals, last years total for the period, subtotals at each major account change (first 2 digits change), to direct the output to printer or file, determine the page length, and whether to print the report for each department... ╔════════════════════════════════════════════════════════════════════════════╗ ║The Trial Balance Report lists all your General Ledger Accounts (balances ║ ║in two columns). ║ ║Not a Report Form (80 characters wide Period or 132 wide Year to Date). ║ ║ ║ ║Select Period -> April 1990 04/01/90 to 04/30/90 ║ ║ ║ ║Include Year to Date Totals? (Y/N) ║ ║ ║ ║Compare Period with Last Years Data? (Y/N) ║ ║ ║ ║Subtotal On Major Account Change? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: TRIAL.TXT ║ ║ ║ ║Enter Page Length: 60 ║ ║ ║ ║Do you want a Department Report? (Y/N) ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ The progress of the report is displayed onto the screen: ╔════════════════════════════════════════════════════════════════════════════╗ ║The Trial Balance Report lists all your General Ledger Accounts (balances ║ ║in two columns). ║ ║Not a Report Form (80 characters wide Period or 132 wide Year to Date). ║ ║ ║ ║Select Period -> April 1990 04/01/90 to 04/30/90 ║ ║ ║ ║Include Year to Date Totals? (Y/N) ║ ║ ║ ║Compare Period with Last Years Data? (Y/N) ║ ║ ║ ║Salaries Payable 17244.24 ║ ║Commissions Payable 6.88 ║ ║Payroll Taxes Payable FICA 18.92 ║ ║Payroll Taxes Payable SUTA 20.96 ║ ║Payroll Taxes Payable FUTA 3.00 ║ ║Employee Tax Payable Fed 445.03 ║ ║Employee Tax Payable FICA 17.07 ║ ║Employee Tax Payable SDI 9.11 ║ ║Federal Income Tax 1.15 ║ ║State Income Tax 3.19 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Standby, While I print this report... Press Esc to Abort... DAYO GL, TJS LAB Page: 42 ■ EXAMPLE OF THE GL TRIAL BALANCE (Without the YTD column and last years balance) General Ledger Trial Balance Page 1 Current Period: June 1990 06/01/90 to 06/30/90 06/15/90 CURRENT ASSETS 32.23 Checking Account #1 64.47 Checking Account #2 96.70 Accounts Receivable 128.94 Inventory 161.17 Inventory Adjustment 193.41 FIXED ASSETS 225.64 Equipment 257.87 Furniture 290.11 Depreciation Equipment 322.34 Vehicles 354.58 Depreciation Vehicles 386.81 Buildings 419.04 Depreciation Buildings 451.38 Land 483.51 Deposits 515.75 Prepaid Rent 547.98 Prepaid Insurance 580.22 Sample Account Number #3 3320.12 LIABILITIES 612.45 Accounts Payable 644.68 Interest Payable 676.92 Salaries Payable 709.15 Commissions Payable 741.39 Payroll Taxes Payable FICA 773.62 Payroll Taxes Payable SUTA 805.86 Payroll Taxes Payable FUTA 838.09 Employee Tax Payable Fed 870.32 Employee Tax Payable FICA 902.56 Employee Tax Payable SDI 934.79 Federal Income Tax 967.03 State Income Tax 999.26 Sales Tax Payable 1031.49 Misc Taxes Payable 1063.73 Employee Deduction #1 1095.96 Employee Deduction #2 1128.20 Employee Deduction #3 1160.43 Employee Deduction #4 1192.67 Employee Deduction #5 1224.90 Employee Deduction #6 1257.13 Employee Deduction #7 1289.37 Notes Payable 1353.84 Warranties 1386.07 EQUITY 1418.30 Capital Stock 1450.54 DAYO GL, TJS LAB Page: 43 ■ BALANCE SHEET The purpose of this report is to provide a means of depicting the financial status of your business. This report is often considered one of the most important financial statements for a company. The prompts consist of Period selection, YTD column, last years balance, and output to printer or file. The progress of the report generation is displayed onto the screen: ╔════════════════════════════════════════════════════════════════════════════╗ ║The Balance Sheet (Report) lists your Assets, Liabilities, and Equity ║ ║General Ledger Accounts (GL_ENTRY starts with 1, 2, or 3). ║ ║Not a Report Form (80 characters wide). ║ ║ ║ ║Select Period -> June 1990 06/01/90 to 06/30/90 ║ ║ ║ ║Include Year to Date Totals? (Y/N) ║ ║ ║ ║Compare Period with Last Years Data? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: BALANCE.TXT ║ ║ ║ ║Employee Deduction #4 1192.67 ║ ║Employee Deduction #5 1224.90 ║ ║Employee Deduction #6 1257.13 ║ ║Employee Deduction #7 1289.37 ║ ║Employee Deduction #8 1321.60 ║ ║Notes Payable 1353.84 ║ ║Warranties 1386.07 ║ ║EQUITY 1418.30 ║ ║Capital Stock 1450.54 ║ ║Current Year Net Income 1482.77 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Standby, While I print this report... Press Esc to Abort... DAYO GL, TJS LAB Page: 44 ■ EXAMPLE OF GL BALANCE SHEET REPORT (Without the YTD column and last years balance) General Ledger Balance Sheet Page 1 Current Period: June 1990 06/01/90 to 06/30/90 06/15/90 CURRENT ASSETS 32.23 Checking Account #1 64.47 Checking Account #2 96.70 Accounts Receivable 128.94 Inventory 161.17 Inventory Adjustment 193.41 FIXED ASSETS 225.64 Equipment 257.87 Furniture 290.11 Depreciation Equipment 322.34 Vehicles 354.58 Depreciation Vehicles 386.81 Buildings 419.04 Depreciation Buildings 451.38 Land 483.51 Deposits 515.75 Prepaid Rent 547.98 Prepaid Insurance 580.22 Sample Account Number #3 3320.12 LIABILITIES 612.45 Accounts Payable 644.68 Interest Payable 676.92 Salaries Payable 709.15 Commissions Payable 741.39 Payroll Taxes Payable FICA 773.62 Payroll Taxes Payable SUTA 805.86 Payroll Taxes Payable FUTA 838.09 Employee Tax Payable Fed 870.32 Employee Tax Payable FICA 902.56 Employee Tax Payable SDI 934.79 Federal Income Tax 967.03 State Income Tax 999.26 Sales Tax Payable 1031.49 Misc Taxes Payable 1063.73 Employee Deduction #1 1095.96 Employee Deduction #2 1128.20 Employee Deduction #3 1160.43 Notes Payable 1353.84 Warranties 1386.07 EQUITY 1418.30 Capital Stock 1450.54 Current Year Net Income 1482.77 Previous Retained Earnings 1515.01 Dividend 1547.24 Drawing 1579.48 ---------- ---------- 8832.17 33974.85 DAYO GL, TJS LAB Page: 45 ■ BALANCE SHEET II (YTD) ╔════════════════════════════════════════════════════════════════════════════╗ ║The Balance Sheet II (Report) is a Year to Date (YTD) summary of your ║ ║Assets, Liabilities, and Equity Accounts (GL_ENTRY starts with 1, 2, or 3). ║ ║Not a Report Form (80 characters wide). ║ ║ ║ ║Select Period -> February 1990 02/01/90 to 02/28/90 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║Subtotal On Major Account Change? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: BALANCE2.TXT ║ ║ ║ ║Enter Page Length: 60 ║ ║ ║ ║Do you wish to page break between Major Account Groups? (Y/N) ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ EXAMPLE OF BALANCE SHEET II (YTD) Balance Sheet Page 1 Year Ending 12/31/90 TJS LAB 09/07/90 Account Name Period Balance........... ------------------------------ ---------- ---------- CURRENT ASSETS Checking Account #1 0.00 Checking Account #2 0.00 Accounts Receivable 0.00 Inventory 0.00 Inventory Adjustment 0.00 ---------- ---------- SUBTOTAL 0.00 0.00 FIXED ASSETS Equipment 0.00 Vehicles 0.00 Buildings 0.00 Depreciation Buildings 0.00 Land 0.00 Prepaid Rent 0.00 ---------- ---------- SUBTOTAL 0.00 0.00 DAYO GL, TJS LAB Page: 46 ■ INCOME & EXPENSES REPORT (PROFIT & LOSS STATEMENT) This report, often call the Profit & Loss Statement, compared to past Income & Expenses reports can explain how and why the proprietorship (net worth & capital) for your business changes over time. The prompts consist of Period selection, YTD column, last years balance, and output to printer or file. If 'to file' option is selected, the default file name will be 'INC_EXP.TXT'. ╔════════════════════════════════════════════════════════════════════════════╗ ║The Income & Expenses Report lists your Income, Sales, Cost of Sales/Cost, ║ ║Expense, and Tax General Ledger Accounts (GL_ENTRY starts with 4,5,7,9) ║ ║Not a Report Form (80 characters wide). ║ ║ ║ ║Select Period -> June 1990 06/01/90 to 06/30/90 ║ ║ ║ ║Include Year to Date Totals? (Y/N) ║ ║ ║ ║Compare Period with Last Years Data? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: INC_EXP.TXT ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO GL, TJS LAB Page: 47 ■ EXAMPLE OF THE GL INCOME & EXPENSES REPORT (Without the YTD column and last years balance) General Ledger Income & Expenses Report Page 1 Current Period: June 1990 06/01/90 to 06/30/90 06/15/90 INCOME, SALES 0.00 SALES 0.00 Returns & Refunds 0.00 COST OF SALES/GOODS 0.00 Beginning Inventory 0.00 Ending Inventory 0.00 Purchases 0.00 Inventory Adjustments 0.00 Freight 0.00 Vendor Returns 0.00 EXPENSES 0.00 Advertising 0.00 EXPENSES, TAXES 0.00 Bank Charges 0.00 Depreciation Office 0.00 Depreciation Vehicles 0.00 Dues & Subscriptions 0.00 Equipment Leases & Rentals 0.00 Insurance 0.00 Interest 0.00 Bad Checks 0.00 Miscellaneous 0.00 Office Supplies 0.00 Postage 0.00 Repairs & Maintenance 0.00 Salaries 0.00 Commissions 0.00 Hourly Rate Wages 0.00 Sick Pay Wages 0.00 Vacation Pay Wages 0.00 Holiday Pay Wages 0.00 Personal Pay Wages 0.00 Other Income Wages 0.00 Contract Labor 0.00 Consultants 0.00 Telephone 0.00 Employee Insurance 0.00 Credit Card Expense 0.00 Show & DEMONSTRATION Expense 0.00 Tax Expense 0.00 SUTA 0.00 FUTA 0.00 SDI 0.00 FICA 0.00 State Income Tax 0.00 DAYO GL, TJS LAB Page: 48 ■ INCOME & EXPENSES REPORT II (YTD) ╔═══════════════════════════════════════════════════════════════════════════╗ ║The Income & Expenses Report II is a Year to Date (YTD) summary of your ║ ║Income, Sales, Cost of Sales/Goods, Expenses, and Tax GL Accounts ║ ║(GL_ENTRY starts with 4,5,7,9). Not a Report Form (80 characters wide). ║ ║ ║ ║Select Period -> February 1990 02/01/90 to 02/28/90 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║Subtotal On Major Account Change? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: INC_EXP2.TXT ║ ║ ║ ║Enter Page Length: 60 ║ ║ ║ ║Do you wish to page break between Major Account Groups? (Y/N) ║ ║ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ■ EXAMPLE OF INCOME & EXPENSES REPORT II Income & Expenses Page 1 Year Ending 12/31/90 TJS LAB 09/07/90 Account Name Period Balance........... ------------------------------ ---------- ---------- INCOME, SALES SALES 0.00 ---------- ---------- SUBTOTAL 0.00 0.00 TOTAL INCOME 0.00 COST OF SALES/GOODS Purchases 0.00 Freight 0.00 ---------- ---------- SUBTOTAL 0.00 0.00 TOTAL COST OF GOODS 0.00 GROSS PROFIT 0.00 EXPENSES Advertising 0.00 EXPENSES, TAXES 0.00 DAYO GL, TJS LAB Page: 49 ■ ASSETS REPORT The Assets report list all your assets to printer or file. The prompts consist of Period selection, YTD column, last years balance, and output to printer or file. If 'to file' option is selected, the default file name will be 'ASSETS.TXT'. ╔════════════════════════════════════════════════════════════════════════════╗ ║The Assets Report lists your Assets Accounts to printer or file. ║ ║General Ledger Accounts (GL_ENTRY starts with 1). ║ ║Not a Report Form (80 characters wide). ║ ║ ║ ║Select Period -> June 1990 06/01/90 to 06/30/90 ║ ║ ║ ║Include Year to Date Totals? (Y/N) ║ ║ ║ ║Compare Period with Last Years Data? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: ASSETS.TXT ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ EXAMPLE OF THE ASSETS REPORT (Without the YTD column and last years balance) General Ledger Assets Report Page 1 Current Period: July 1990 07/01/90 to 07/31/90 06/15/90 CURRENT ASSETS 199.00 Checking Account #1 0.00 Accounts Receivable 0.00 Inventory 0.00 Inventory Adjustment 0.00 FIXED ASSETS 0.00 Equipment 0.00 Vehicles 0.00 Buildings 0.00 Land 0.00 Deposits 0.00 Prepaid Rent 0.00 Prepaid Insurance 0.00 Sample Account Number #3 0.00 ---------- ---------- 199.00 0.00 DAYO GL, TJS LAB Page: 50 ■ ASSETS REPORT II (YTD) ╔═══════════════════════════════════════════════════════════════════════════╗ ║The Assets Report Sheet II is a Year to Date (YTD) summary of your ║ ║Assets Accounts (GL_ENTRY starts with 1). ║ ║Not a Report Form (80 characters wide). ║ ║ ║ ║Select Period -> February 1990 02/01/90 to 02/28/90 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║Subtotal On Major Account Change? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: ASSETS2.TXT ║ ║ ║ ║Enter Page Length: 60 ║ ║ ║ ║Do you wish to page break between Major Account Groups? (Y/N) ║ ║ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ■ EXAMPLE OF ASSETS REPORT II (YTD) Assets Page 1 Year Ending 12/31/90 TJS LAB 09/07/90 Account Name Period Balance........... ------------------------------ ---------- ---------- CURRENT ASSETS Checking Account #1 0.00 Accounts Receivable 0.00 Inventory 0.00 Inventory Adjustment 0.00 ---------- ---------- SUBTOTAL 0.00 0.00 FIXED ASSETS Equipment 0.00 Vehicles 0.00 Depreciation Vehicles 0.00 Buildings 0.00 Deposits 0.00 Prepaid Rent 0.00 ---------- ---------- SUBTOTAL 0.00 0.00 TOTAL ASSETS 0.00 DAYO GL, TJS LAB Page: 51 ■ LIABILITY REPORT The Liability report lists your Liability Accounts to printer or file. The prompts consist of Period selection, YTD column, last years balance, and output to printer or file. If 'to file' option is selected, the default file name will be 'LIABIL.TXT'. ╔════════════════════════════════════════════════════════════════════════════╗ ║The Liability Report lists your Liability Accounts to printer or file. ║ ║General Ledger Accounts (GL_ENTRY starts with 2). ║ ║Not a Report Form (80 characters wide). ║ ║ ║ ║Select Period -> June 1990 06/01/90 to 06/30/90 ║ ║ ║ ║Include Year to Date Totals? (Y/N) ║ ║ ║ ║Compare Period with Last Years Data? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: LIABIL.TXT ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO GL, TJS LAB Page: 52 ■ EXAMPLE OF THE LIABILITY REPORT (Without the YTD column and last years balance) General Ledger Liability Report Page 1 Current Period: July 1990 07/01/90 to 07/31/90 06/15/90 LIABILITIES 0.00 Accounts Payable 0.00 Interest Payable 0.00 Salaries Payable 0.00 Commissions Payable 0.00 Payroll Taxes Payable FICA 0.00 Payroll Taxes Payable SUTA 0.00 Payroll Taxes Payable FUTA 0.00 Employee Tax Payable Fed 0.00 Employee Tax Payable FICA 0.00 Employee Tax Payable SDI 0.00 Federal Income Tax 0.00 State Income Tax 0.00 Sales Tax Payable 0.00 Misc Taxes Payable 0.00 Employee Deduction #1 0.00 Employee Deduction #2 0.00 Employee Deduction #3 0.00 Employee Deduction #4 0.00 Employee Deduction #5 0.00 Employee Deduction #6 0.00 Employee Deduction #7 0.00 Employee Deduction #8 0.00 Notes Payable 0.00 Warranties 0.00 ---------- ---------- 0.00 0.00 DAYO GL, TJS LAB Page: 53 ■ LIABILITY REPORT II (YTD) ╔═══════════════════════════════════════════════════════════════════════════╗ ║The Liability Report II is a Year to Date (YTD) summary of your ║ ║Liability Accounts (GL_ENTRY starts with 2. ║ ║Not a Report Form (80 characters wide). ║ ║ ║ ║Select Period -> February 1990 02/01/90 to 02/28/90 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║Subtotal On Major Account Change? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: LIABIL2.TXT ║ ║ ║ ║Enter Page Length: 60 ║ ║ ║ ║Do you wish to page break between Major Account Groups? (Y/N) ║ ║ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ■ EXAMPLE OF LIABILITY REPORT II (YTD) Liabilities Page 1 Year Ending 12/31/90 TJS LAB 09/07/90 Account Name Period Balance........... ------------------------------ ---------- ---------- LIABILITIES Accounts Payable 0.00 Interest Payable 0.00 Commissions Payable 0.00 Payroll Taxes Payable FICA 0.00 Federal Income Tax 0.00 State Income Tax 0.00 Sales Tax Payable 0.00 Employee Deduction #1 0.00 Employee Deduction #2 0.00 Notes Payable 0.00 Warranties 0.00 ---------- ---------- SUBTOTAL 0.00 0.00 TOTAL LIABILITY 0.00 DAYO GL, TJS LAB Page: 54 ■ EQUITY REPORT The Equity Report lists your Equity Accounts to printer or file. The prompts consist of Period selection, YTD column, last years balance, and output to printer or file. If 'to file' option is selected, the default file name will be 'EQUITY.TXT'. ╔════════════════════════════════════════════════════════════════════════════╗ ║The Equity Report lists your Equity Accounts to printer or file. ║ ║General Ledger Accounts (GL_ENTRY starts with 3). ║ ║Not a Report Form (80 characters wide). ║ ║ ║ ║Select Period -> June 1990 06/01/90 to 06/30/90 ║ ║ ║ ║Include Year to Date Totals? (Y/N) ║ ║ ║ ║Compare Period with Last Years Data? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: EQUITY.TXT ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ EXAMPLE OF THE GL EQUITY REPORT (Without the YTD column and last years balance) General Ledger Equity Report Page 1 Current Period: July 1990 07/01/90 to 07/31/90 06/15/90 EQUITY 0.00 Capital Stock 0.00 Current Year Net Income 0.00 Previous Retained Earnings 0.00 Dividend 0.00 Drawing 0.00 ---------- ---------- 0.00 0.00 DAYO GL, TJS LAB Page: 55 ■ EQUITY REPORT II (YTD) ╔═══════════════════════════════════════════════════════════════════════════╗ ║The Equity Report II is a Year to Date (YTD) summary of your ║ ║Equity Accounts (GL_ENTRY starts with 3). ║ ║Not a Report Form (80 characters wide). ║ ║ ║ ║Select Period -> February 1990 02/01/90 to 02/28/90 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║Subtotal On Major Account Change? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: EQUITY2.TXT ║ ║ ║ ║Enter Page Length: 60 ║ ║ ║ ║Do you wish to page break between Major Account Groups? (Y/N) ║ ║ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ■ EXAMPLE OF EQUITY REPORT II (YTD) Equity Page 1 Year Ending 12/31/90 TJS LAB 09/07/90 Account Name Period Balance........... ------------------------------ ---------- ---------- EQUITY Capital Stock 0.00 Current Year Net Income 0.00 Previous Retained Earnings 0.00 Dividend 0.00 Drawing 0.00 ---------- ---------- SUBTOTAL 0.00 0.00 TOTAL EQUITY 0.00 DAYO GL, TJS LAB Page: 56 ■ INCOME REPORT The Income Report lists your Income Accounts to printer or file. The prompts consist of Period selection, YTD column, last years balance, and output to printer or file. If 'to file' option is selected, the default file name will be 'INCOME.TXT'. ╔════════════════════════════════════════════════════════════════════════════╗ ║The Income Report lists your Income Accounts to printer or file. ║ ║General Ledger Accounts (GL_ENTRY starts with 4). ║ ║Not a Report Form (80 characters wide). ║ ║ ║ ║Select Period -> June 1990 06/01/90 to 06/30/90 ║ ║ ║ ║Include Year to Date Totals? (Y/N) ║ ║ ║ ║Compare Period with Last Years Data? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: INCOME.TXT ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ EXAMPLE OF THE INCOME REPORT (Without the YTD column and last years balance) General Ledger Income Accounts Report Page 1 Current Period: July 1990 07/01/90 to 07/31/90 06/15/90 INCOME, SALES -199.00 SALES 0.00 Returns & Refunds 0.00 ---------- ---------- 0.00 -199.00 DAYO GL, TJS LAB Page: 57 ■ INCOME REPORT II (YTD) ╔═══════════════════════════════════════════════════════════════════════════╗ ║The Income Report II is a Year to Date (YTD) summary of your ║ ║Income Accounts (GL_ENTRY starts with 4). ║ ║Not a Report Form (80 characters wide). ║ ║ ║ ║Select Period -> February 1990 02/01/90 to 02/28/90 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║Subtotal On Major Account Change? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: INCOME2.TXT ║ ║ ║ ║Enter Page Length: 60 ║ ║ ║ ║Do you wish to page break between Major Account Groups? (Y/N) ║ ║ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ■ EXAMPLE OF INCOME REPORT II (YTD) Income Page 1 Year Ending 12/31/90 TJS LAB 09/07/90 Account Name Period Balance........... ------------------------------ ---------- ---------- INCOME, SALES SALES 0.00 Returns & Refunds 0.00 ---------- ---------- SUBTOTAL 0.00 0.00 TOTAL INCOME 0.00 DAYO GL, TJS LAB Page: 58 ■ COST OF GOODS REPORT The Cost of Goods Report lists your Cost of Goods Accounts to printer or file. The prompts consist of Period selection, YTD column, last years balance, and output to printer or file. If 'to file' option is selected, the default file name will be 'COSTS.TXT'. ╔════════════════════════════════════════════════════════════════════════════╗ ║The Cost of Goods Report lists your Cost of Goods Accounts to printer ║ ║or file. General Ledger Accounts (GL_ENTRY starts with 5). ║ ║Not a Report Form (80 characters wide). ║ ║ ║ ║Select Period -> June 1990 06/01/90 to 06/30/90 ║ ║ ║ ║Include Year to Date Totals? (Y/N) ║ ║ ║ ║Compare Period with Last Years Data? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: COSTS.TXT ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ ■ EXAMPLE OF THE COST OF GOODS REPORT General Ledger Cost of Goods Report Page 1 Current Period: July 1990 07/01/90 to 07/31/90 06/15/90 COST OF SALES/GOODS 0.00 Beginning Inventory 0.00 Ending Inventory 0.00 Purchases 0.00 Inventory Adjustments 0.00 Freight 0.00 Vendor Returns 0.00 ---------- ---------- 0.00 0.00 DAYO GL, TJS LAB Page: 59 ■ COST OF GOODS REPORT II (YTD) ╔═══════════════════════════════════════════════════════════════════════════╗ ║The Cost of Goods Report is a Year to Date (YTD) summary of yourinter ║ ║Income Accounts (GL_ENTRY starts with 5).RY starts with 5). ║ ║Not a Report Form (80 characters wide). ║ ║ ║ ║Select Period -> February 1990 02/01/90 to 02/28/90 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║Subtotal On Major Account Change? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: INCOME2.TXT ║ ║ ║ ║Enter Page Length: 60 ║ ║ ║ ║Do you wish to page break between Major Account Groups? (Y/N) ║ ║ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ■ EXAMPLE OF COST OF GOODS REPORT II (YTD) Cost of Goods Page 1 Year Ending 12/31/90 TJS LAB 09/07/90 Account Name Period Balance........... ------------------------------ ---------- ---------- COST OF SALES/GOODS Beginning Inventory 0.00 Ending Inventory 0.00 Purchases 0.00 Inventory Adjustments 0.00 Freight 0.00 Vendor Returns 0.00 ---------- ---------- SUBTOTAL 0.00 0.00 TOTAL COST OF GOODS 0.00 DAYO GL, TJS LAB Page: 60 ■ EXPENSES REPORT The Expenses Report lists your Expenses Accounts to printer or file. The prompts consist of Period selection, YTD column, last years balance, and output to printer or file. If 'to file' option is selected, the default file name will be 'EXPENSES.TXT'. ╔════════════════════════════════════════════════════════════════════════════╗ ║The Expenses Report lists your Expenses Accounts to printer or file. ║ ║General Ledger Accounts (GL_ENTRY starts with 7). ║ ║Not a Report Form (80 characters wide). ║ ║ ║ ║Select Period -> June 1990 06/01/90 to 06/30/90 ║ ║ ║ ║Include Year to Date Totals? (Y/N) ║ ║ ║ ║Compare Period with Last Years Data? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: EXPENSES.TXT ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO GL, TJS LAB Page: 61 ■ EXAMPLE OF THE EXPENSES REPORT (Without the YTD column and last years balance) General Ledger Expenses Report Page 1 Current Period: July 1990 07/01/90 to 07/31/90 06/15/90 EXPENSES 0.00 Advertising 0.00 EXPENSES, TAXES 0.00 Bank Charges 0.00 Depreciation Office 0.00 Depreciation Vehicles 0.00 Depreciation Building 0.00 Depreciation Other 0.00 Dues & Subscriptions 0.00 Equipment Leases & Rentals 0.00 Insurance 0.00 Interest 0.00 Licenses & Fees 0.00 Bad Checks 0.00 Miscellaneous 0.00 Office Supplies 0.00 Postage 0.00 Rent 0.00 Repairs & Maintenance 0.00 Salaries 0.00 Commissions 0.00 Hourly Rate Wages 0.00 Piecework Wages 0.00 Sick Pay Wages 0.00 Vacation Pay Wages 0.00 Holiday Pay Wages 0.00 Personal Pay Wages 0.00 Other Income Wages 0.00 Contract Labor 0.00 Consultants 0.00 Telephone 0.00 Employee Insurance 0.00 Credit Card Expense 0.00 Show & DEMONSTRATION Expense 0.00 ---------- ---------- 0.00 0.00 DAYO GL, TJS LAB Page: 62 ■ EXPENSES REPORT II (YTD) ╔═══════════════════════════════════════════════════════════════════════════╗ ║The Expenses Report II is a Year to Date (YTD) summary of your ║ ║Expense Accounts (GL_ENTRY starts with 7 & 9). ║ ║Not a Report Form (80 characters wide). ║ ║ ║ ║Select Period -> February 1990 02/01/90 to 02/28/90 ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║Subtotal On Major Account Change? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: EXPENSE2.TXT ║ ║ ║ ║Enter Page Length: 60 ║ ║ ║ ║Do you wish to page break between Major Account Groups? (Y/N) ║ ║ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ■ EXAMPLES OF EXPENSES REPORT II EXPENSES Page 1 Year Ending 12/31/90 TJS LAB 09/07/90 Account Name Period Balance........... ------------------------------ ---------- ---------- EXPENSES Licenses & Fees 0.00 Credit Card Expense 0.00 ---------- ---------- SUBTOTAL 0.00 0.00 TOTAL SELLING EXPENSES 0.00 TAX EXPENSES FICA 0.00 Other Tax 0.00 ---------- ---------- SUBTOTAL 0.00 0.00 TOTAL OVERHEAD EXPENSES 0.00 TOTAL EXPENSES 0.00 DAYO GL, TJS LAB Page: 63 ■ TRANSACTION REPORT The Transaction report will list all General Ledger transactions from the database GLTRANS.DBF to printer or file. There are 4 dBase (tm) compatible Report Forms for the 1st 5 options. The last report option (All Debits & Credits) is a 'hard coded' report. The first prompts are for the start and ending dates for the report. The dates correspond to the current accounting period. The second prompt is to select the index (order) and/or type of report. ╔═══════════════════════════════════════════════════════╗ ║The Transaction Report will list all General Ledger ║ ║Transactions for a selected date range. ║ ║Subtotals are created if you select an index of CLASS ║ ║DEBIT, or CREDIT. Report Forms: TRANS(1,2,3,4).FRM ║ ║for the 1st 5 report options. Width: 95-110 char ║ ║Current Period: (05/01/90 to 05/31/90) ║ ║Start Date: 01/01/90 Ending Date: 01/31/90 ║ ║ ║ ║Select the Option ->Transaction Number ║ ║ Class Code ║ ║ Transaction Description ║ ║ Debit Account Number ║ ║ Credit Account Number ║ ║ All Debits & Credits ║ ╚═══════════════════════════════════════════════════════╝ The remaining prompts consists of output to printer or file. If 'to file' option is selected, the default file name will be 'TRAN' plus the report form number (1-6) and '.TXT', ie: 'TRAN6.TXT'. ╔═══════════════════════════════════════════════════════╗ ║The Transaction Report will list all General Ledger ║ ║Transactions for a selected date range. ║ ║Subtotals are created if you select an index of CLASS ║ ║DEBIT, or CREDIT. Report Forms: TRANS(1,2,3,4).FRM ║ ║for the 1st 5 report options. Width: 95-110 char ║ ║Current Period: (05/01/90 to 05/31/90) ║ ║Start Date: 01/01/90 Ending Date: 01/31/90 ║ ║ ║ ║Select the Option ->All Debits & Credits ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: TRANS6.TXT ║ ║ ║ ╚═══════════════════════════════════════════════════════╝ DAYO GL, TJS LAB Page: 64.1 The progress of the last report (option 6) is displayed onto the screen in very patriotic (U.S.A.) colors: ╔════════════════════════════════════════════════════════════════════════════╗ ║ Current Account: 72020-026010 Salesman Salaries ║ ║┌┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┬┐ ║ ║├▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒▒┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┤ ║ ║├▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓▓┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┤ ║ ║├███████████████████████████████████████████┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┼┤ ║ ║└┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┴┘ ║ ║1% 50% Finis║ ╚════════════════════════════════════════════════════════════════════════════╝ Standby, While I print this report... Press Esc to Abort... DAYO GL, TJS LAB Page: 64 ■ CHART OF ACCOUNTS REPORT This report simply lists the Chart of Accounts to printer or file. The lists contains only the GL Account number (GL_ENTRY) and the name of the account. Note, the report is double spaced. The prompts consists of selection of the Accounting Period and output to printer or file. If 'to file' option is selected, the default file name will be 'COA.TXT'. ╔═══════════════════════════════════════════════════════╗ ║The Chart of Accounts Report lists all your General ║ ║Ledger Accounts to printer or file. ║ ║Report Form Name: COA.FRM ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: COA.TXT ║ ╚═══════════════════════════════════════════════════════╝ DAYO GL, TJS LAB Page: 65 ■ EXAMPLE OF THE CHART OF ACCOUNTS LIST/REPORT Page No. 1 06/16/90 General Ledger Chart of Accounts GL Entry Description ------------ ------------------------------ ** Account: 10 10000-000000 CURRENT ASSETS _____________________ ** Account: 11 11001-000000 Checking Account #1 _____________________ 11002-000000 Checking Account #2 _____________________ 11003-000000 Accounts Receivable _____________________ 11004-000000 Inventory _____________________ 11005-000000 Inventory Adjustment _____________________ ** Account: 12 12000-000000 FIXED ASSETS _____________________ 12001-000000 Equipment _____________________ 12002-000000 Furniture _____________________ 12003-000000 Depreciation Equipment _____________________ 12004-000000 Vehicles _____________________ 12005-000000 Depreciation Vehicles _____________________ 12006-000000 Buildings _____________________ 12007-000000 Depreciation Buildings _____________________ 12008-000000 Land _____________________ 12009-000000 Deposits _____________________ 12010-000000 Prepaid Rent _____________________ 12011-000000 Prepaid Insurance _____________________ DAYO GL, TJS LAB Page: 66 ■ PERIODS REPORT This is a special report in that it also contain the routine to maintenance your Accounting Periods database PERIODS.DBF. The first prompt gives you the option to browse the database PERIODS.DBF. If you select Y to this prompt, the lower half of the screen will become a browse of the database PERIODS.DBF. The function keys available are displayed at the bottom of the screen. *** Note, the record number determines the period number! The first record must contain the name and date ranges for your first period. The default is January, but you may start your year at a different time. ╔════════════════════════════════════════════════════════════════════════════╗ ║The Periods Report Lists the current accounting periods to printer or file. ║ ║You also have the option of browsing the Periods Database (GLPERIOD.DBF) ║ ║prior to printing. Not a Report Form (80 characters wide). ║ ║ ║ ║Do you wish to browse the Periods Database (GLPERIOD.DBF)? (Y/N) ║ ║ ║ PERIOD FROM_DATE TO_DATE ───────────────────────────────────────────╥───────────╥───────────────────── January 1990 ║ 01/01/90 ║ 01/31/90 February 1990 ║ 02/01/90 ║ 02/28/90 March 1990 ║ 03/01/90 ║ 03/31/90 April 1990 ║ 04/01/90 ║ 04/30/90 May 1990 ║ 05/01/90 ║ 05/31/90 June 1990 ║ 06/01/90 ║ 06/30/90 July 1990 ║ 07/01/90 ║ 07/31/90 August 1990 ║ 08/01/90 ║ 08/31/90 September 1990 ║ 09/01/90 ║ 09/30/90 October 1990 ║ 10/01/90 ║ 10/31/90 November 1990 ║ 11/01/90 ║ 11/30/90 ───────────────────────────────────────────╨───────────╨───────────────────── Esc (Exit) F1 (Help) F2 (Edit) Ctrl N (Add) Ctrl U (Delete) The next prompt(s) consists of output to printer or file. If 'to file' option is selected, the default file name will be 'PERIODS.TXT'. ╔════════════════════════════════════════════════════════════════════════════╗ ║The Periods Report Lists the current accounting periods to printer or file. ║ ║You also have the option of browsing the Periods Database (GLPERIOD.DBF) ║ ║prior to printing. Not a Report Form (80 characters wide). ║ ║ ║ ║Do you wish to browse the Periods Database (GLPERIOD.DBF)? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: PERIODS.TXT ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO GL, TJS LAB Page: 67 ■ EXAMPLE OF THE ACCOUNTING PERIODS LIST/REPORT General Ledger Accounting Periods Page 1 06/15/90 Period Date From Date To ------------------------------ --------- -------- January 1990 01/01/90 01/31/90 February 1990 02/01/90 02/28/90 March 1990 03/01/90 03/31/90 April 1990 04/01/90 04/30/90 May 1990 05/01/90 05/31/90 June 1990 06/01/90 06/30/90 July 1990 07/01/90 07/31/90 August 1990 08/01/90 08/31/90 September 1990 09/01/90 09/30/90 October 1990 10/01/90 10/31/90 November 1990 11/01/90 11/30/90 December 1990 12/01/90 12/31/90 ■ BUDGETS REPORT This report requires a wide carriage printer, laser, or very tiny print since its width is over 200 characters. The Budgets report lists all the default budgets to printer or file. The first prompt is for output to printer or file. If 'to file' option is selected, the default file name will be 'BUDGETS.TXT'. ╔═══════════════════════════════════════════════════════╗ ║The Budgets Report lists budgets by period for each ║ ║of your General Ledger Accounts. ║ ║Prints to printer or file (200 characters wide!). ║ ║Report Form Name: BUDGETS.FRM ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: BUDGETS.TXT ║ ╚═══════════════════════════════════════════════════════╝ DAYO GL, TJS LAB Page: 68 ■ CURRENT BUDGET REPORT The Current Budget report lists only the budget information for the current (actually selected) Accounting Period. The prompts consists of selection of the Accounting Period and output to printer or file. If 'to file' option is selected, the default file name will be 'BUDGETSC.TXT'. The progress of the report generation is displayed onto the screen: ╔════════════════════════════════════════════════════════════════════════════╗ ║The Current Budget Report lists your Chart of Accounts with current Balance ║ ║and Budget status. Prints to printer or file (80 characters wide). ║ ║Not a Report Form. ║ ║ ║ ║Select Period -> June 1990 06/01/90 to 06/30/90 ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: BUDGETSC.TXT ║ ║GL Entry Balance Budget Difference ║ ║ ║ ║20107-000000 838.09 1854.69 1016.60 ║ ║20106-000000 805.86 1783.37 977.51 ║ ║20105-000000 773.62 1712.02 938.40 ║ ║20004-000000 741.39 1640.70 899.31 ║ ║20003-000000 709.15 1569.35 860.20 ║ ║20002-000000 676.92 1498.02 821.10 ║ ║20001-000000 644.68 1426.68 782.00 ║ ║20000-000000 612.45 1355.35 742.90 ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO GL, TJS LAB Page: 69 ■ EXAMPLE OF THE CURRENT BUDGETS REPORT General Ledger Chart of Accounts Page 1 Current Balance & Budget Status Report 06/15/90 GL Account Name/Description Balance Budget Difference ------------ ------------------------- ---------- ---------- ---------- 10000-000000 CURRENT ASSETS 32.23 71.32 39.09 11001-000000 Checking Account #1 64.47 142.67 78.20 11002-000000 Checking Account #2 96.70 214.00 117.30 11003-000000 Accounts Receivable 128.94 285.34 156.40 11004-000000 Inventory 161.17 356.67 195.50 11005-000000 Inventory Adjustment 193.41 428.02 234.61 12000-000000 FIXED ASSETS 225.64 499.34 273.70 12001-000000 Equipment 257.87 570.67 312.80 12002-000000 Furniture 290.11 642.01 351.90 12003-000000 Depreciation Equipment 322.34 713.34 391.00 12004-000000 Vehicles 354.58 784.69 430.11 12005-000000 Depreciation Vehicles 386.81 856.01 469.20 12006-000000 Buildings 419.04 927.34 508.30 12007-000000 Depreciation Buildings 451.38 998.68 547.40 12008-000000 Land 483.51 1070.01 586.50 12009-000000 Deposits 515.75 1141.35 625.60 12010-000000 Prepaid Rent 547.98 1212.68 664.70 12011-000000 Prepaid Insurance 580.22 1284.03 703.81 12300-000000 Sample Account Number #3 3320.12 7347.43 4027.31 20000-000000 LIABILITIES 612.45 1355.35 742.90 20001-000000 Accounts Payable 644.68 1426.68 782.00 20002-000000 Interest Payable 676.92 1498.02 821.10 20003-000000 Salaries Payable 709.15 1569.35 860.20 20004-000000 Commissions Payable 741.39 1640.70 899.31 20105-000000 Payroll Taxes Payable FIC 773.62 1712.02 938.40 20106-000000 Payroll Taxes Payable SUT 805.86 1783.37 977.51 20107-000000 Payroll Taxes Payable FUT 838.09 1854.69 1016.60 20108-000000 Employee Tax Payable Fed 870.32 1926.02 1055.70 20109-000000 Employee Tax Payable FICA 902.56 1997.37 1094.81 20110-000000 Employee Tax Payable SDI 934.79 2068.69 1133.90 20111-000000 Federal Income Tax 967.03 2140.04 1173.01 20112-000000 State Income Tax 999.26 2211.36 1212.10 20113-000000 Sales Tax Payable 1031.49 2282.69 1251.30 20114-000000 Misc Taxes Payable 1063.73 2354.03 1290.30 20115-000000 Employee Deduction #1 1095.96 2425.36 1329.40 20116-000000 Employee Deduction #2 1128.20 2496.71 1368.51 20117-000000 Employee Deduction #3 1160.43 2568.03 1407.60 20118-000000 Employee Deduction #4 1192.67 2639.38 1446.71 20119-000000 Employee Deduction #5 1224.90 2710.70 1485.80 20120-000000 Employee Deduction #6 1257.13 2782.03 1524.90 20121-000000 Employee Deduction #7 1289.37 2853.38 1564.01 20122-000000 Employee Deduction #8 1321.60 2924.70 1603.10 21001-000000 Notes Payable 1353.84 2996.05 1642.21 21002-000000 Warranties 1386.07 3067.37 1681.30 30000-000000 EQUITY 1418.30 3138.70 1720.40 30001-000000 Capital Stock 1450.54 3210.05 1759.51 30002-000000 Current Year Net Income 1482.77 3281.37 1798.60 DAYO GL, TJS LAB Page: 70 ■ CLASS CODE REPORT The Class Code report lists all your Classification records (from the database GLCLASS.DBF to printer or file. The first prompt is for the index (5 to pick from). ╔═══════════════════════════════════════════════════════╗ ║The Class Code Report lists all your General ║ ║Ledger Class Codes to printer or file. ║ ║Report Form Name: CLASSRPT.FRM ║ ║ ║ ║Select the Index -> Class Code ║ ║ Debit Account Number ║ ║ Credit Account Number ║ ║ Class Code Description ║ ║ Database ║ ╚═══════════════════════════════════════════════════════╝ The next prompt is for output to printer or file. If 'to file' option is selected, the default file name will be 'CLASSRPT.TXT'. ╔═══════════════════════════════════════════════════════╗ ║The Class Code Report lists all your General ║ ║Ledger Class Codes to printer or file. ║ ║Report Form Name: CLASSRPT.FRM ║ ║ ║ ║Select the Index -> Class Code ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: CLASSRPT.TXT ║ ╚═══════════════════════════════════════════════════════╝ The report is too wide to display here, but contains the fields: Class Code, Description, Debit Account Number, Credit Account Number, Database, Field Expression, Condition/Filter, and Date. DAYO GL, TJS LAB Page: 71 ■ PURGE TRANSACTIONS The Purge Transaction option permanently removes selected GL transaction records from the database GLTRANS.DBF and optionally saves them to a history database GLHIST.DBF. The default is to save the purged data. It is recommended that this process take place only after a full backup of your databases. ╔═══[ PURGE TRANSACTIONS ]══════════════════════════════╗ ║Because of the large volume of transactions, it is ║ ║often necessary to purge transactions from old/past ║ ║accounting periods. Use this option to permanently ║ ║remove General Ledger transaction records from the ║ ║database GLTRANS.DBF. ║ ║Note, you have the option to save transactions into ║ ║a history database called GLHIST.DBF. This option is ║ ║set from the Configuration Menu. It is currently set ║ ║to SAVE purged transactions. ║ ║ ║ ║Do you wish to continue with this purge process? (Y/N) ║ ║ ║ ║Are you sure? (Y/N) ║ ║ █▀▀█ █ █ █▀▀█ █▀▀█ █▀▀ ║ ║ █▄▄█ █ █ █▄▄█ █ █▄ ║ ║ █ █ █ █▀█▄ █ ▀█ █ ║ ║ █ ████ █ █ ████ ███ ║ ╚═══════[ REQUIRES EXCLUSIVE USE OF GLTRANS.DBF ]═══════╝ Multiple prompts are presented before this process runs. The next prompt wants the date you wish to stop the transaction deletion at. All transactions created before this date will be removed from the database GLTRANS.DBF. Note, DAYO will not allow the deletion of transactions that are less than 90 days old... ╔═══[ PURGE TRANSACTIONS ]══════════════════════════════╗ ║Because of the large volume of transactions, it is ║ ║often necessary to purge transactions from old/past ║ ║accounting periods. Use this option to permanently ║ ║remove General Ledger transaction records from the ║ ║database GLTRANS.DBF. ║ ║Note, you have the option to save transactions into ║ ║a history database called GLHIST.DBF. This option is ║ ║set from the Configuration Menu. It is currently set ║ ║to SAVE purged transactions. ║ ║ ║ ║Purge all transaction on or before date: 12/17/89 ║ ║ ║ ║Note, Can only purge transactions over 90 days old. ║ ║ █▀▀█ █ █ █▀▀█ █▀▀█ █▀▀ ║ ║ █▄▄█ █ █ █▄▄█ █ █▄ ║ ║ █ █ █ █▀█▄ █ ▀█ █ ║ ║ █ ████ █ █ ████ ███ ║ ╚═══════[ REQUIRES EXCLUSIVE USE OF GLTRANS.DBF ]═══════╝ DAYO GL, TJS LAB Page: 72 The printing of a report is optional, but if you decide to print one (and it is highly recommended you do, and keep for records) you will be prompted to direct the output to printer or file. If you select the 'to file' option, the file name will default to 'PURGE.TXT' ╔═══[ PURGE TRANSACTIONS ]══════════════════════════════╗ ║Because of the large volume of transactions, it is ║ ║often necessary to purge transactions from old/past ║ ║accounting periods. Use this option to permanently ║ ║remove General Ledger transaction records from the ║ ║database GLTRANS.DBF. ║ ║Note, you have the option to save transactions into ║ ║a history database called GLHIST.DBF. This option is ║ ║set from the Configuration Menu. It is currently set ║ ║to SAVE purged transactions. ║ ║ ║ ║Purge all transaction on or before date: 12/17/89 ║ ║ ║ ║Do you want a report of purged records? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: PURGE.TXT ║ ║ ║ ║ ║ ╚═══════[ REQUIRES EXCLUSIVE USE OF GLTRANS.DBF ]═══════╝ The progress of this routine and report is displayed upon the screen: ╔═══[ PURGE TRANSACTIONS ]══════════════════════════════╗ ║ █▀▀█ █ █ █▀▀█ █▀▀█ █▀▀ ║ ║ █▄▄█ █ █ █▄▄█ █ █▄ ║ ║ █ █ █ █▀█▄ █ ▀█ █ ║ ║ █ ████ █ █ ████ ███ ║ ║ TRANSACTION DESCRIPTION AMOUNT DATE ║ ║ 900527000034 REG SALE ARH 7352.40 05/27/90 ║ ║ 900527000033 ARH 67.06 05/27/90 ║ ║ 900527000032 ARH 55.56 05/27/90 ║ ║ 900527000031 ARH 3.82 05/27/90 ║ ║ 900527000030 REG SALE 230.28 05/27/90 ║ ║ 900527000029 REG SALE ARH 60.80 05/27/90 ║ ║ 900527000028 REG SALE ARH 950.02 05/27/90 ║ ║ 900527000027 REG SALE ARH 659.60 05/27/90 ║ ║ 900527000026 REG SALE ARH 65.06 05/27/90 ║ ║ 900527000025 REG SALE ARH 2340.67 05/27/90 ║ ║ 900527000024 REG SALE ARH 65.20 05/27/90 ║ ║ 900527000023 REG SALE 240.13 05/27/90 ║ ║ 900527000022 REG SALE ARH 23.24 05/27/90 ║ ║ 900527000021 REG SALE ARH 235.31 05/27/90 ║ ╚╡███████████████████████─┼──┼──┼──┼──┼──┼──┼──┼──┼──┼─╞╝ Standby, While I Do A Purge! Press Esc to Abort... DAYO GL, TJS LAB Page: 73 After passing through the database GLTRANS.DBF, the process starts to PACK that database. This process is critical, and no interruption should take place while it is performing it! The following message is displayed onto the screen: ┌──────────────────────────────────────────────────────────────────────────┐ │ PACKING THE DATABASE GLTRANS.DBF! DO NOT INTERRUPT THIS PROCESS! │ └──────────────────────────────────────────────────────────────────────────┘ ■ ROLL ACCOUNTING YEAR This is a 'once a year' routine that is run after the closing of an Accounting year. The Chart of Accounts balances in the database GL.DBF are zeroed out. The budget fields in the database GL.DBF are updated by one of 3 methods. Previous year balances are kept in the field RETAINED if the flag field RETAIN is marked true. Run this routine with caution and only after a full backup of ALL your databases. ╔═══[ ROLL ACCOUNTING YEAR ]════════════════════════════╗ ║Use this routine to zero out all all balances in the ║ ║chart of accounts (GLACCT.DBF), update budgets, and ║ ║permanently remove past year General Ledger ║ ║transaction records from the database GLTRANS.DBF. ║ ║Note, you have the option to save transactions into ║ ║a history database called GLHIST.DBF. This option is ║ ║set from the Configuration Menu. It is currently set ║ ║to SAVE purged transactions. ║ ║ ║ ║Do you wish to continue this process? (Y/N) ║ ║Are you sure? (Y/N) ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ █▀▀█ ▄██▄ █ █ █ █ █▀▀ █ █▀▀█ ║ ║ █▄▄█ █ █ █ █ ▀█ █▀ █▄ █▀█ █▄▄█ ║ ║ █▀█▄ █ █ █ █ ▀█▀ █ ▄█▄█▄ █▀█▄ ║ ║ █ █ ▀██▀ ███ ███ █ ███ █ █ █ █ ║ ╚═══════[ REQUIRES EXCLUSIVE USE OF GLTRANS.DBF ]═══════╝ Budgets in the Chart of Accounts (GL.DBF) are updated by one of the following methods. LEAVE THE SAME - Do not change the value of the budgets RESET TO ZERO - Reset the budgets to 0 UPDATED BY A FACTOR - Increase current budgets by a factor (ie: 25%) DAYO GL, TJS LAB Page: 74 At this prompt, select the desired option, then press enter/return. ╔═══[ ROLL ACCOUNTING YEAR ]════════════════════════════╗ ║Use this routine to zero out all all balances in the ║ ║chart of accounts (GLACCT.DBF), update budgets, and ║ ║permanently remove past year General Ledger ║ ║transaction records from the database GLTRANS.DBF. ║ ║Note, you have the option to save transactions into ║ ║a history database called GLHIST.DBF. This option is ║ ║set from the Configuration Menu. It is currently set ║ ║to SAVE purged transactions. ║ ║ ║ ║Budgets can be left the same, zeroed, or update ║ ║a factor. ║ ║ ║ ║Select Option -> LEAVE THE SAME ║ ║ RESET TO ZERO ║ ║ UPDATED BY A FACTOR ║ ║ █▀▀█ ▄██▄ █ █ █ █ █▀▀ █ █▀▀█ ║ ║ █▄▄█ █ █ █ █ ▀█ █▀ █▄ █▀█ █▄▄█ ║ ║ █▀█▄ █ █ █ █ ▀█▀ █ ▄█▄█▄ █▀█▄ ║ ║ █ █ ▀██▀ ███ ███ █ ███ █ █ █ █ ║ ╚═══════[ REQUIRES EXCLUSIVE USE OF GLTRANS.DBF ]═══════╝ If you select the UPDATE BY FACTOR option, you will be prompted to enter the value of the factor. The factor is a number you wish to multiple the current budgets with. For example, to keep the budgets the same, you would select a factor of '1'. To decrease the current budgets by 10%, you would multiple the budget with a factor of '.9'. To increase the budgets by 25%, you would select a budget of '1.35'. The default is '1.0', which is simply leaving the budgets the same. ╔═══[ ROLL ACCOUNTING YEAR ]════════════════════════════╗ ║Use this routine to zero out all all balances in the ║ ║chart of accounts (GLACCT.DBF), update budgets, and ║ ║permanently remove past year General Ledger ║ ║transaction records from the database GLTRANS.DBF. ║ ║Note, you have the option to save transactions into ║ ║a history database called GLHIST.DBF. This option is ║ ║set from the Configuration Menu. It is currently set ║ ║to SAVE purged transactions. ║ ║ ║ ║Budgets will be: UPDATED BY A FACTOR ║ ║ ║ ║BUDGET * FACTOR = NEW BUDGET ║ ║(ie: 1.3 to increase budget by 20%) ║ ║Enter factor to multiply budgets with: 1.0000 ║ ║ ║ ║ █▀▀█ ▄██▄ █ █ █ █ █▀▀ █ █▀▀█ ║ ║ █▄▄█ █ █ █ █ ▀█ █▀ █▄ █▀█ █▄▄█ ║ ║ █▀█▄ █ █ █ █ ▀█▀ █ ▄█▄█▄ █▀█▄ ║ ║ █ █ ▀██▀ ███ ███ █ ███ █ █ █ █ ║ ╚═══════[ REQUIRES EXCLUSIVE USE OF GLTRANS.DBF ]═══════╝ DAYO GL, TJS LAB Page: 75 From this point on, the routine mirrors the PURGE TRANSACTIONS routine. The next prompt wants the date you wish to stop the transaction deletion at. All transactions created before this date will be removed from the database GLTRANS.DBF. Note, DAYO WILL ALLOW the deletion of transactions that are less than the current date (today). ╔═══[ ROLL ACCOUNTING YEAR ]════════════════════════════╗ ║Use this routine to zero out all all balances in the ║ ║chart of accounts (GLACCT.DBF), update budgets, and ║ ║permanently remove past year General Ledger ║ ║transaction records from the database GLTRANS.DBF. ║ ║Note, you have the option to save transactions into ║ ║a history database called GLHIST.DBF. This option is ║ ║set from the Configuration Menu. It is currently set ║ ║to SAVE purged transactions. ║ ║ ║ ║Budgets will be: UPDATED BY A FACTOR Factor: 1 ║ ║ ║ ║Enter End Date of Last Year: 12/01/89 ║ ║ ║ ║ ║ ║ █▀▀█ ▄██▄ █ █ █ █ █▀▀ █ █▀▀█ ║ ║ █▄▄█ █ █ █ █ ▀█ █▀ █▄ █▀█ █▄▄█ ║ ║ █▀█▄ █ █ █ █ ▀█▀ █ ▄█▄█▄ █▀█▄ ║ ║ █ █ ▀██▀ ███ ███ █ ███ █ █ █ █ ║ ╚═══════[ REQUIRES EXCLUSIVE USE OF GLTRANS.DBF ]═══════╝ The printing of a report is optional, but if you decide to print one (and it is highly recommended you do, and keep for records) you will be prompted to direct the output to printer or file. If you select the 'to file' option, the file name will default to 'ROLL.TXT' ╔═══[ ROLL ACCOUNTING YEAR ]════════════════════════════╗ ║Use this routine to zero out all all balances in the ║ ║chart of accounts (GLACCT.DBF), update budgets, and ║ ║permanently remove past year General Ledger ║ ║transaction records from the database GLTRANS.DBF. ║ ║Note, you have the option to save transactions into ║ ║a history database called GLHIST.DBF. This option is ║ ║set from the Configuration Menu. It is currently set ║ ║to SAVE purged transactions. ║ ║ ║ ║Budgets will be: UPDATED BY A FACTOR Factor: 1 ║ ║ ║ ║Enter End Date of Last Year: 12/01/89 ║ ║ ║ ║Do you want a report? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File ) ║ ║ ║ ║Enter File Name: ROLL.TXT ║ ╚═══════[ REQUIRES EXCLUSIVE USE OF GLTRANS.DBF ]═══════╝ DAYO GL, TJS LAB Page: 76 ■ SAVING THE CHART OF ACCOUNTS The Chart of Accounts is automatically copied/saved to a database named 'ROLL' plus the year. ╔═══[ ROLL ACCOUNTING YEAR ]════════════════════════════╗ ║ █▀▀█ ▄██▄ █ █ █ █ █▀▀ █ █▀▀█ ║ ║ █▄▄█ █ █ █ █ ▀█ █▀ █▄ █▀█ █▄▄█ ║ ║ █▀█▄ █ █ █ █ ▀█▀ █ ▄█▄█▄ █▀█▄ ║ ║ █ █ ▀██▀ ███ ███ █ ███ █ █ █ █ ║ ║ Working on the Chart of Accounts Balances & Budgets ║ ║ ║ ║Making a copy of the Chart of Accounts! ║ ║ ║ ║Coping GLACCT.DBF to ROLL90.DBF ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚═══════[ REQUIRES EXCLUSIVE USE OF GLTRANS.DBF ]═══════╝ The progress of this routine and report is displayed upon the screen: Note, the new budget values are scrolled onto the upper right of the screen: ╔═══════════════════╗ ╔═══[ ROLL ACCOUNTING YEAR ]════════════════════════════╗║ PERIOD BUDGET ║ ║ █▀▀█ ▄██▄ █ █ █ █ █▀▀ █ █▀▀█ ║╟───────────────────╢ ║ █▄▄█ █ █ █ █ ▀█ █▀ █▄ █▀█ █▄▄█ ║║ ║ ║ █▀█▄ █ █ █ █ ▀█▀ █ ▄█▄█▄ █▀█▄ ║║ 9 0.00║ ║ █ █ ▀██▀ ███ ███ █ ███ █ █ █ █ ║║ 8 0.00║ ║ Working on the Chart of Accounts Balances & Budgets ║║ 7 583.51║ ║ GL ENTRY NAME DATE LASTDATE ║║ 6 1070.01║ ║ 12008-000000 Land / / / / ║║ 5 1070.01║ ║ 12007-000000 Depreciation Buildings / / / / ║║ 4 586.50║ ║ 12006-000000 Buildings / / / / ║║ 3 586.50║ ║ 12005-000000 Depreciation Vehicles / / / / ║║ 2 586.50║ ║ 12004-000000 Vehicles / / / / ║║ 1 586.50║ ║ 12003-000000 Depreciation Equipment / / / / ║║ ║ ║ 12002-000000 Furniture / / / / ║║ ║ ║ 12001-000000 Equipment / / / / ║║ ║ ║ 12000-000000 FIXED ASSETS / / 06/14/90 ║║ ║ ║ 11005-000000 Inventory Adjustment / / / / ║╚═══════════════════╝ ║ 11004-000000 Inventory / / / / ║ ║ 11003-000000 Accounts Receivable / / / / ║ ║ 11002-000000 Checking Account #2 / / / / ║ ╚╡███████──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼─╞╝ Standby, While I Roll Last Year! Press Esc to Abort... DAYO GL, TJS LAB Page: 77 ■ GRAPH - BUDGET SUMMARY This special report produces a graphic report of your year to date budget status to printer or file using the extended graphics characters ( ASCII codes greater than 128 ). Be sure your printer is capable of printer the extended characters, and is set to do so. The only prompts are for output to printer or file. If the 'to file' option is selected, the default file name will be 'GR_SUM.TXT'. ╔═══════════════════════════════════════════════════════╗ ║This report produces a Summary Budget Graph for ║ ║each General Ledger Account. ║ ║Width of report is 80 characters. ║ ║Does not use a Report Form. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: GR_SUM.TXT ║ ║ ║ ║ ║ ║ ║ ║ █▀▀█ █▀▀█ ▄█▄ █▀▀█ █ █ ┌─────────┬─────────┐ ║ ║ █ █▄▄█ █ █ █▄▄█ █▄▄█ │███████████████████│▓▓▓ ║ ║ █ ▀█ █▀█▄ ▄███▄ █ █ █ 0% 50% 100% ║ ║ ████ █ █ █ █ █ █ █ GL BUDGET SUMMARY ║ ╚═══════════════════════════════════════════════════════╝ The progress of the report generation is printed onto the screen: ╔═══════════════════════════════════════════════════════╗ ║ █▀▀█ █▀▀█ ▄█▄ █▀▀█ █ █ ┌─────────┬─────────┐ ║ ║ █ █▄▄█ █ █ █▄▄█ █▄▄█ │███████████████████│▓▓▓ ║ ║ █ ▀█ █▀█▄ ▄███▄ █ █ █ 0% 50% 100% ║ ║ ████ █ █ █ █ █ █ █ GL BUDGET SUMMARY ║ ║ ║ ║ ║ ║ ║ ╚╡█████─┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼─╞╝ General Ledger Chart of Accounts Budget Graph - Summary Date Run: 06/15/90 Account: 10000-000000 CURRENT ASSETS 06/14/90 Account: 11001-000000 Checking Account #1 / / Account: 11002-000000 Checking Account #2 / / Account: 11003-000000 Accounts Receivable / / Account: 11004-000000 Inventory / / Account: 11005-000000 Inventory Adjustment / / Account: 12000-000000 FIXED ASSETS 06/14/90 Account: 12001-000000 Equipment / / Account: 12002-000000 Furniture / / Account: 12003-000000 Depreciation Equipment / / Standby, While I Print This Report! Press Esc to Abort... DAYO GL, TJS LAB Page: 78 ■ EXAMPLE OF THE BUDGETS SUMMARY GRAPH REPORT General Ledger Chart of Accounts Page 1 Budget Graph - Summary Date Run: 06/15/90 Account: 10000-000000 CURRENT ASSETS 06/14/90 Total Balance: 225.61 Total Budget: 431.33 Difference: -205.62 ┌──────────────────────────────┬────────────────────────────────┐ │████████████████████████████████ │ 52.318% 0%............................50%..............................100% Account: 11001-000000 Checking Account #1 / / Total Balance: 451.39 Total Budget: 762.61 Difference: -311.32 ┌──────────────────────────────┬────────────────────────────────┐ │█████████████████████████████████████ │ 59.177% 0%............................50%..............................100% Account: 11002-000000 Checking Account #2 / / Total Balance: 676.90 Total Budget: 1093.90 Difference: -417.00 ┌──────────────────────────────┬────────────────────────────────┐ │██████████████████████████████████████ │ 61.880% 0%............................50%..............................100% Account: 11003-000000 Accounts Receivable / / Total Balance: 902.58 Total Budget: 1425.22 Difference: -522.64 ┌──────────────────────────────┬────────────────────────────────┐ │███████████████████████████████████████ │ 63.329% 0%............................50%..............................100% Account: 13000-000000 CURRENT ASSETS #2 06/14/90 Total Balance: 225.61 Total Budget: 431.33 Difference: -205.62 ┌──────────────────────────────┬────────────────────────────────┐ │████████████████████████████████ │ 52.318% 0%............................50%..............................100% Account: 13001-000000 Checking Account #4 / / Total Balance: 451.39 Total Budget: 762.61 Difference: -311.32 ┌──────────────────────────────┬────────────────────────────────┐ │█████████████████████████████████████ │ 59.177% 0%............................50%..............................100% Account: 13002-000000 Checking Account #5 / / Total Balance: 676.90 Total Budget: 1093.90 Difference: -417.00 ┌──────────────────────────────┬────────────────────────────────┐ │██████████████████████████████████████ │ 61.880% 0%............................50%..............................100% Account: 13003-000000 Accounts Receivable #2 / / Total Balance: 902.58 Total Budget: 1425.22 Difference: -522.64 ┌──────────────────────────────┬────────────────────────────────┐ │███████████████████████████████████████ │ 63.329% 0%............................50%..............................100% DAYO GL, TJS LAB Page: 79 ■ GRAPH - BUDGET DETAIL This special report produces a detailed graphic report for each of your GL Accounts. Each Budget is printed onto the report. The report is printed to printer or file using the extended graphics characters ( ASCII codes greater than 128 ). Be sure your printer is capable of printer the extended characters, and is set to do so. The first prompts are for output to printer or file. If the 'to file' option is selected, the default file name will be 'GR_DET.TXT'. The final prompt is for a page eject option to be performed after each GL Account. ╔═══════════════════════════════════════════════════════╗ ║This report produces a Budget Graph for each period, ║ ║of every General Ledger Account. ║ ║Width of report is 80 characters. ║ ║Does not use a Report Form. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: GR_DET.TXT ║ ║ ║ ║Page eject after each GL Account? (Y/N) ║ ║ ║ ║ █▀▀█ █▀▀█ ▄█▄ █▀▀█ █ █ ┌─────────┬─────────┐ ║ ║ █ █▄▄█ █ █ █▄▄█ █▄▄█ │███████████████████│▓▓▓ ║ ║ █ ▀█ █▀█▄ ▄███▄ █ █ █ 0% 50% 100% ║ ║ ████ █ █ █ █ █ █ █ GL BUDGET DETAIL ║ ╚═══════════════════════════════════════════════════════╝ The progress of the report generation is displayed onto the screen: ╔═══════════════════════════════════════════════════════╗ ║ █▀▀█ █▀▀█ ▄█▄ █▀▀█ █ █ ┌─────────┬─────────┐ ║ ║ █ █▄▄█ █ █ █▄▄█ █▄▄█ │███████████████████│▓▓▓ ║ ║ █ ▀█ █▀█▄ ▄███▄ █ █ █ 0% 50% 100% ║ ║ ████ █ █ █ █ █ █ █ GL BUDGET DETAIL ║ ║ ║ ║ ║ ╚╡┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼──┼─╞╝ Period: 7 Balance: 0.00 Budget: 132.23 Difference: -132.23 ┌──────────────────────────────┬────────────────────────────────┐ │ │ 0.756% 0%............................50%..............................100% Period: 8 Balance: 0.00 Budget: 0.00 Difference: 0.00 ┌──────────────────────────────┬────────────────────────────────┐ │ │ 0.000% 0%............................50%..............................100% Period: 9 Balance: 0.00 Budget: 0.00 Difference: 0.00 ┌──────────────────────────────┬────────────────────────────────┐ │ │ 0.000% 0%............................50%..............................100% Standby, While I Print This Report! Press Esc to Abort... DAYO GL, TJS LAB Page: 80 ■ EXAMPLE OF THE BUDGETS DETAIL GRAPH REPORT General Ledger Chart of Accounts Page 1 Budget Graph - Detailed Date Run: 06/15/90 Account: 10000-000000 CURRENT ASSETS 06/14/90 Period: 1 Balance: 32.23 Budget: 39.09 Difference: -6.86 ┌──────────────────────────────┬────────────────────────────────┐ │███████████████████████████████████████████████████ │ 82.451% 0%............................50%..............................100% Period: 2 Balance: 32.23 Budget: 39.09 Difference: -6.86 ┌──────────────────────────────┬────────────────────────────────┐ │███████████████████████████████████████████████████ │ 82.451% 0%............................50%..............................100% Period: 3 Balance: 32.23 Budget: 39.09 Difference: -6.86 ┌──────────────────────────────┬────────────────────────────────┐ │███████████████████████████████████████████████████ │ 82.451% 0%............................50%..............................100% Period: 4 Balance: 32.23 Budget: 39.09 Difference: -6.86 ┌──────────────────────────────┬────────────────────────────────┐ │███████████████████████████████████████████████████ │ 82.451% 0%............................50%..............................100% Period: 5 Balance: 32.23 Budget: 71.32 Difference: -39.09 ┌──────────────────────────────┬────────────────────────────────┐ │████████████████████████████ │ 45.191% 0%............................50%..............................100% Period: 6 Balance: 32.23 Budget: 71.32 Difference: -39.09 ┌──────────────────────────────┬────────────────────────────────┐ │████████████████████████████ │ 45.191% 0%............................50%..............................100% Period: 7 Balance: 32.23 Budget: 132.23 Difference: -100.00 ┌──────────────────────────────┬────────────────────────────────┐ │███████████████ │ 24.374% 0%............................50%..............................100% DAYO GL, TJS LAB Page: 81 ■ FINANCIAL STATEMENT This complex report will display subtotals of a selected period. The report is in three (3) parts: 1. The Basic Subtotal (Top Of First Page), ie: Current Year to Date -------------- -------------- Assets: 348.54 348.54 Income: 99,071.00 99,071.00 Liabilities: 1,579.69 1,579.69 Equity: 714.00 714.00 Cost of Goods: 35,034.98 35,034.98 Expenses: 7,099.41 7,099.41 2. User Configured Subtotals, ie: Subtotals Current Year to Date -------------- -------------- Current Assets 40.76 40.76 Fixed Assets 305.74 305.74 Total Assets 348.54 348.54 Liabilities 1,579.69 1,579.69 Equity 714.00 714.00 Income/Sales 99,071.00 99,071.00 Cost of Goods 35,034.98 35,034.98 Gross Profit 64,036.02 64,036.02 Expenses/Overhead Type I 5,301.62 5,301.62 Expenses/Overhead Type II 1,797.79 1,797.79 Total Expenses 7,099.41 7,099.41 Operating Profit & Loss 91,971.59 91,971.59 3. Department Basic Subtotals, ie: Current Year to Date -------------- -------------- SALEM HOUSE Assets: 2.04 2.04 Income: 1,406.43 1,406.43 Liabilities: 714.00 714.00 Equity: 99,071.00 99,071.00 Cost of Goods: 35,034.98 35,034.98 Expenses: 2,044.43 2,044.43 DAYO GL, TJS LAB Page: 82 The SUBTOTALS are computed based on records/entries in the GL Tables databases (GLTABLEH.DBF, GLTABLED.DBF, and GLDEPT.DBF). The records in the database GLTABLEH.DBF contain the heading and the control number (GLTAB) for each SUBTOTAL. A record for all GL entries that comprises a SUBTOTAL are contained in the database GLTABLED.DBF. At report time, the GL entries are added/subtracted together for each control number (GLTAB) based on the field SIGN (+ or -). There is no limit to the number of SUBTOTALS. The Departmental Financial Statement is just a listing of the Basic Subtotals for each Department as defined/contained in the database GLDEPT.DBF. Also note that the Department Code Setup may have to be maintained in the Configurations Menu if you do not use the third through the fifth digits of the GL entry (the default) to designate the department. Department Code: ──┐ ┌┼┐ │││ 12345-123456 The first prompt is to select the period you wish to report: ╔════════════════════════════════════════════════════════════════════════════╗ ║The Financial Statement is user configurable. See the user manual on ║ ║setting up SUBTOTALS. ║ ║Not a Report Form. ║ ║ ║ ║Select Period -> April 1990 04/01/90 to 04/30/90 ║ ║ May 1990 05/01/90 to 05/31/90 ║ ║ June 1990 06/01/90 to 06/30/90 ║ ║ July 1990 07/01/90 to 07/31/90 ║ ║ August 1990 08/01/90 to 08/31/90 ║ ║ September 1990 09/01/90 to 09/30/90 ║ ║ October 1990 10/01/90 to 10/31/90 ║ ║ November 1990 11/01/90 to 11/30/90 ║ ║ December 1990 12/01/90 to 12/31/90 ║ ║ January 1991 01/01/91 to 01/31/91 ║ ║ February 1991 02/01/91 to 02/28/91 ║ ║ March 1991 03/01/91 to 03/31/91 ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ DAYO GL, TJS LAB Page: 83 The Financial Statement can be directed to the printer or to a file, and can also be embedded with laser codes for a 'prettier' report for the laser owners. The printing of the Departmental portion of the report is optional. ╔════════════════════════════════════════════════════════════════════════════╗ ║The Financial Statement is user configurable. See the user manual on ║ ║setting up SUBTOTALS. ║ ║Not a Report Form. ║ ║ ║ ║Select Period -> April 1990 04/01/90 to 04/30/90 ║ ║ ║ ║Send Output to which type printer? -> Standard Printer ║ ║ ║ ║Print Financial Statement for Departments? (Y/N) ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: FINSTATE.TXT ║ ║ ║ ║Cost of Goods 35,034.98 35,034.98 ║ ║Income/Sales 99,071.00 99,071.00 ║ ║Equity 714.00 714.00 ║ ║Liabilities 1,579.69 1,579.69 ║ ║Total Assets 348.54 348.54 ║ ║Fixed Assets 305.74 305.74 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Standby, While I compute, then print this report... Press Esc to Abort... DAYO GL, TJS LAB Page: 84 ■ EXAMPLE OF A FINANCIAL STATEMENT General Ledger Financial Statement Page 1 Current Period: April 1990 04/01/90 to 04/30/90 TJS LAB 08/13/90 Current Year to Date -------------- -------------- Assets: 348.54 348.54 Income: 99,071.00 99,071.00 Liabilities: 1,579.69 1,579.69 Equity: 714.00 714.00 Cost of Goods: 35,034.98 35,034.98 Expenses: 7,099.41 7,099.41 Subtotals Current Year to Date -------------- -------------- Current Assets 40.76 40.76 Fixed Assets 305.74 305.74 Total Assets 348.54 348.54 Liabilities 1,579.69 1,579.69 Equity 714.00 714.00 Income/Sales 99,071.00 99,071.00 Cost of Goods 35,034.98 35,034.98 Gross Profit 64,036.02 64,036.02 Expenses/Overhead Type I 5,301.62 5,301.62 Expenses/Overhead Type II 1,797.79 1,797.79 Total Expenses 7,099.41 7,099.41 Operating Profit & Loss 91,971.59 91,971.59 DAYO GL, TJS LAB Page: 85 ■ EXAMPLE OF A DEPARTMENTAL FINANCIAL STATEMENT General Ledger Department Financial Statement 08/13/90 TJS LAB Page 1 Current Period: April 1990 04/01/90 to 04/30/90 Current Year to Date -------------- -------------- SALEM HOUSE Assets: 2.04 2.04 Income: 1,406.43 1,406.43 Liabilities: 714.00 714.00 Equity: 99,071.00 99,071.00 Cost of Goods: 35,034.98 35,034.98 Expenses: 2,044.43 2,044.43 HARLEM HOUSE Assets: 40.76 40.76 Income: 173.26 173.26 Liabilities: 0.00 0.00 Equity: 0.00 0.00 Cost of Goods: 0.00 0.00 Expenses: 5,054.98 5,054.98 BELEMY HOUSE Assets: 305.74 305.74 Income: 0.00 0.00 Liabilities: 0.00 0.00 Equity: 0.00 0.00 Cost of Goods: 0.00 0.00 Expenses: 0.00 0.00 DAYO GL, TJS LAB Page: 86 ■ CONFIGURATION STATUS REPORT This report lists all your DAYO General Ledger Configuration settings and values to printer or file. The only prompts are for output to printer or file. If the 'to file' option is selected, the default file name will be 'CONFIG.TXT'. ╔═══════════════════════════════════════════════════════╗ ║The Configuration Status Settings Report lists all of ║ ║configuration settings (found in file DAYOGL.CFG). ║ ║This is Not a Report Form. ║ ║ ║ ║Send Output to Printer? (Y/N) ( No -> To File) ║ ║ ║ ║Enter File Name: CONFIG.TXT ║ ╚═══════════════════════════════════════════════════════╝ ■ EXAMPLE OF THE CONFIGURATION STATUS REPORT +++++++++++++++++++++++++++++++++++++++++++++++++ + DAYO GENERAL LEDGER CONFIGURATION REPORT + +++++++++++++++++++++++++++++++++++++++++++++++++ 06/15/90 21:32:56 Company Name: YOUR COMPAY, INC Address Line 1: Attn: Accounting Department Address Line 2: P.O. BOX 5555 City, State Zip: ANYCITY, ST 55555-5555 Telephone: (800)-555-5555 Use Account Budgets: Yes Current GL Posting Period: 6 Inventory Database Location: \DAYOINV\ POS Database Location: \DAYOPOS\ BackOrder Database Location: \DAYOBO\ Customer Database Location: \DAYOAR\ AP Database Location: \DAYOAP\ MRP Database Location: \DAYOMRP\ EOP Database Location: \DAYOEOP\ Payroll Database Location: Assets Database Location: Last Transaction Number: 0 Save Purged Transactions: Yes Report Printer Type: LASER PRINTER Report Printer Port: LPT1 Visual Indexing: Yes Automatically Reindex Daily: Yes Color: Yes High Intensity: Yes DAYO GL, TJS LAB Page: 87 ■ VIEW REPORTS ON SCREEN This routine was provided to aid the 'fight to stop the cutting down of trees in the world' by offering you the option to view your reports on your screen. The only limitation is on the size of the report. No reports can be viewed if they are over 32,000 bytes. (Just kidding about those trees...) Due to compiler problems (handling of memory), this routine tends to 'hang' your computer. It is not recommended you use this option if your machine is performing multitasking programs. At the first prompt, type and enter the name of the report you wish to view. ╔════════════════════════════════════════════════════════════════════════════╗ ║Use this option to view any report written to disk. ║ ║Press Enter/Return on an empty prompt to display all files with the ║ ║extension of '.TXT'. ║ ║File size limited to 32,000 bytes. ║ ║ ║ ║Enter Report File Name to View On Screen: ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ If the file does not exist, or you press enter on an empty prompt, a window will appear showing all reports in the current directory. It is assumed that all reports will have the extension of '.TXT', which is the DAYO standard. All reports are displayed in the window, even if they are too large... ╔═══════════════════════════════════════╗ ║ File Name Size Date Used ║ ╟──────────────┬────────────┬───────────╢ ║DAYOERR.TXT │ 1090 │ 06/15/90 ║ ║BALANCE.TXT │ 3555 │ 06/15/90 ║ ║GL900615.TXT │ 79 │ 06/15/90 ║ ║CONFIG.TXT │ 1209 │ 06/15/90 ║ ║BUDGETSC.TXT │ 4129 │ 06/15/90 ║ ║CLASSRPT.TXT │ 1058 │ 06/02/90 ║ ║COA.TXT │ 1158 │ 06/02/90 ║ ┌────────────────────────┐ ║GL900602.TXT │ 1759 │ 06/02/90 ║ │ Highlight the Report │ ║PERIODS.TXT │ 968 │ 06/15/90 ║ │ using the Up or Down │ ║TRANS3.TXT │ 659 │ 06/02/90 ║ │ arrow keys, then press │ ║TRIAL.TXT │ 6712 │ 06/15/90 ║ │ Enter/Return. │ ║INC_EXP.TXT │ 3291 │ 06/15/90 ║ └────────────────────────┘ ║TRANS1.TXT │ 659 │ 06/15/90 ║ ║ASSETS.TXT │ 1300 │ 06/15/90 ║ ║LIABIL.TXT │ 1987 │ 06/15/90 ║ ║EQUITY.TXT │ 714 │ 06/15/90 ║ ╚══════════════╧════════════╧═══════════╝ DAYO GL, TJS LAB Page: 88 ■ REPORT VIEWING SCREEN The report viewing screen uses the complete screen. The top line displays the report name. The bottom lines show you the function keys, all 2 of them. Also displayed at the bottom of the screen is the current row/column of the cursor position. DAYOGL View Reports │ File Name: COA.TXT General Ledger Chart of Accounts GL Entry Description ------------ ------------------------------ 10000-000000 CURRENT ASSETS _____________________ 11000-000000 FIXED ASSETS _____________________ 20000-000000 LIABILITIES _____________________ 30000-000000 EQUITY _____________________ 34530-023400 MISC EXPENSES _____________________ 40000-000000 INCOME, SALES _____________________ 50000-000000 COST OF SALES/GOODS _____________________ 70000-000000 EXPENSES _____________________ 71000-000000 EXPENSES, TAXES _____________________ Esc (Exit) F1 (Help) 4/0 DAYO GL, TJS LAB Page: 89 ■ PRINTER DRIVER (SETUP) This routine was added to preclude you from having to get out of your seat to change (mess with) the printer to get it to print correctly. The most important printer selections (ie: font size, lines per inch, orientation, ...) are made easy to evoke. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ║ ║ ║ Select Option -> Eject ║ ║ Line feed ║ ║ Normal Size ║ ║ Use this routine to set your Small/Condensed ║ ║ printer up with one or more Bold On ║ ║ of the setup strings and Bold Off ║ ║ commands listed to the right. 6 Lines per Inch ║ ║ 8 Lines per Inch ║ ║ Select the 'Change Printer Print Landscape (Laser Only) ║ ║ Default' option to change Print Portrait (Laser Only) ║ ║ printer types. Reset Printer ║ ║ Current printer is set to: Print Special String 1 ║ ║ Okidata Print Special String 2 ║ ║ Print Special String 3 ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) ■ PRINTER DRIVER OPTIONS There are 18 printer driver options to select from. The last option is to set the default printer, and the next to last is a 'SHELL' function that runs a DOS command or program. The remainder are strings/codes that are sent to the printer. Eject Print Portrait (Laser Only) Line feed Reset Printer Normal Size Print Special String 1 Small/Condensed Print Special String 2 Bold On Print Special String 3 Bold Off Print Special String 4 6 Lines per Inch Print Special String 5 8 Lines per Inch Run DOS Command/Program Print Landscape (Laser Only) Change Default Printer DAYO GL, TJS LAB Page: 90 ■ CHANGE DEFAULT PRINTER The last option is to change/set the default printer. This printer driver routine comes with 4 default printer types, Epson, HP Laser, Star, and Okidata. You can add (Ctrl N) as many as you want. ╔════════════════════════════════════════════════════════════════════════════╗ ║ █▄██░█▄██░███░█░ █░█████░███░█▄██░ █▄██▄ █▄██░███░█░ █░███░█▄██░ ║ ║ █░ █░█░ █░ █░ ██░ █░ █░ █░ █░ █░ █░ █░█░ █░ █░ █░ █░█░ █░ █░ ║ ║ █▀██░████░ █░ ███░█░ █░ ██░ ████░ █░ █░████░ █░ █▄ ▄█░██ ████░ ║ ║ █░ █░█░ █░ █░███░ █░ █░ █░█░ █░ █░█░█░ █░ █░█░ █░ █░█░ ║ ║ █░ █░▀█░ █░ █░ ██░ █░ █░ █░▀█░ █░ █░█░▀█░ █░ █▄█░ █░ █░▀█░ ║ ║ █░ █░ █░███░█░ █░ █░ ███░█░ █░ █▀██▀ █░ █░███░ █░ ███░█░ █░ ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ Current Default Printer is set to: Okidata ║ ╟────────────────────────────────────────────────────────────────────────────╢ ║ NAME LINEFEED ║ ║─────────────────────────────────────╥──────────────────────────────────────║ ║ Epson & Compatibles ║ CHR(10) ║ ║ HP Laser & Compatibles ║ CHR(10) ║ ║ Star Micro Gemini ║ CHR(10) ║ ║ Okidata ║ CHR(10) ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ║ ╚════════════════════════════════════════════════════════════════════════════╝ Esc (Exit) Enter/Return (Make Default) F2 (Edit) Ctrl N (Add) 1/4 DAYO GL, TJS LAB Page: 91 ■ FULL SCREEN EDIT - F2 When entering the printer codes, the string must be in the valid format or it will not be printed later when requested... ┌───────────[ EDIT PRINTER DRIVER SETUP CODES - FULL SCREEN EDIT ]───────────┐ │ NAME: Epson & Compatibles │ │ LINEFEED: CHR(10) │ │ NORMAL: CHR(27)+CHR(18) │ │ SMALL: CHR(27)+CHR(15) │ │ BOLDON: CHR(27)+CHR(69) │ │ BOLDOFF: CHR(27)+CHR(70) │ │ _6LPI: CHR(27)+CHR(50) │ │ _8LPI: CHR(27)+CHR(48) │ │ PORTRAIT: │ │ LANDSCAPE: │ │ RESET: CHR(27)+CHR(64) │ │ SPEC_STR1: │ │ SPEC_STR2: │ │ SPEC_STR3: │ │ SPEC_STR4: │ │ SPEC_STR5: │ │ RUN_CMD: │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ Press Esc to Abort, PgUp/PgDn to Save and Exit ■ PRINTER DRIVER DATABASE FIELD DEFINITIONS NAME - Name of printer. Type in anything you wish here LINEFEED - Code to advance printer one line NORMAL - Normal font/character size SMALL - Small font/character size BOLDON - Bold/Emphasized BOLDOFF - Bold/Emphasized off _6LPI - Code to set printer to print 6 lines per inch _8LPI - Code to set printer to print 8 lines per inch PORTRAIT - Code to set lazer printer to print upright (normal) LANDSCAPE - Code to set lazer printer to print sideways RESET - Reset printer code SPEC_STR1 - Any special printer string, ie: print double, skip perforation, SPEC_STR2 - print very tiny, ... SPEC_STR3 - " SPEC_STR4 - " SPEC_STR5 - " RUN_CMD - DOS command or program, ie: CAPTURE p0 nff,SPOOL ON, ... DAYO GL, TJS LAB Page: 92 ■ CONFIGURATION The configurations settings, are all accessed from within the CONFIGURATION menu (option 6 from the main menu). DAYO GL Version 2.0 TJS LAB CONFIG ┌───[February 1991]──┐ ╔════════════════════════╗ │S M T W T F S │ ║ CONFIGURATION ║ █▄██▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ╟────────────────────────╢ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│ ║ Company Name ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│ ║ Company Address ║ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│ ║ Company Telephone ║ █░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│ ║ Account Budgets ║ █▀██▀ █░ █░ █░ ▀███▀ │29 30 31 │ ║ Inventory Location ║ │ │ ║ POS Location ║ └────────────────────┘ ║ Back Orders Location ║ ║ Customer (AR) Location ║ ▄████░ ████░ █░ █░ ████░ █▄██▄ ▄█▄ ▀█░ ║ AP Location ║ █░ █░ ██░ █░ █░ █░ █░ █░█░ █░ ║ Payroll Location ║ █░ ███░ ███░█░ ███░ █░ █░ █░█░ █░ ║ Assets Location ║ █░█▀█░ █░ █░███░ █░ █▄▄█▀ ▄███▄ █░ ║ MRP Location ║ █░ █░ █░ █░ ██░ █░ █▀█▄▄ █░ █░ █░ ║ EOP Location ║ ▀███▀ ████░ █░ █░ ████░ █░ █░ █░ █░ ████░ ║ Last Transaction # ║ ║ Save Transactions ║─────╖ ▀█░ ████░ █▄██▄ ▄████░ ████░ █▄██▄ ║ Chart of Accounts View ║ Size║ █░ █░ █░ █░ █░ █░ █░ █░ ║ Report Printer Type ║73993║ █░ ███░ █░ █░ █░ ███░ █░ █░ ╟────────────────────────╢21763║ █░ █░ █░ █░ █░█▀█░ █░ █▄▄█▀ ║ Select Option ║17920║ █░ █░ █░ █░ █░ █░ █░ █▀█▄▄ ╚════════════════════════╝═════╝ ████░ ████░ █▀██▀ ▀███▀ ████░ █░ █░ ■ CONFIGURATION LISTING Company Name EOP Location Company Address Last Transaction # Company Telephone Save Transactions Account Budgets Chart of Accounts View Inventory Location Stop at Wrong CLASS POS Location Department Code Setup Back Orders Location Report Printer Type Customer (AR) Location Report Printer Port AP Location Visual Indexing Payroll Location Auto Daily Indexing Assets Location Color MRP Location High Intensity DAYO GL, TJS LAB Page: 93 ■ COMPANY NAME, ADDRESS & TELEPHONE Each field for this option is limited to 30 characters, 14 for the telephone... ┌──────────────────────────────[ COMPANY NAME ]──────────────────────────────┐ │ Enter Your Company Name: YOUR COMPANY, INC │ └────────────────────────────────────────────────────────────────────────────┘ ┌────────────────────────────[ COMPANY ADDRESS ]─────────────────────────────┐ │ Address Line 1: Attn: Accounting │ │ Address Line 2: P.O. BOX 5555 │ │ City, State ZIP: ANYCITY, ST 55555-5555 │ └────────────────────────────────────────────────────────────────────────────┘ ┌───────────────────────────[ COMPANY TELEPHONE ]────────────────────────────┐ │ Enter Your Company Telephone: 800-555-5555 │ └────────────────────────────────────────────────────────────────────────────┘ ■ ACCOUNT BUDGETS ┌────────────────────────────[ ACCOUNT BUDGETS ]─────────────────────────────┐ │ If you are using Account Budgets (the BUDGETxx field in the database │ │ GL.DBF) then set this option to Y (Yes). Default is Y (Yes) │ │ │ │ Will you be using Account Budgets? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ INVENTORY LOCATION/DIRECTORY ┌──────────────────────[ INVENTORY LOCATION/DIRECTORY ]──────────────────────┐ │ The location of the DAYO Inventory (INV.DBF) does not have to be in the │ │ same drive/directory as DAYO GL. If you have installed DAYO Inventory │ │ into a different directory, you need to tell DAYO GL where to find │ │ the inventory database (INV.DBF). Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOINV\ │ │ The drive designation is optional (if same as DAYO GL). │ │ │ │ Enter Location: \DAYOINV\ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 94 ■ POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY ┌────────────[ POINT OF SALE (POS) DATABASES LOCATION/DIRECTORY ]────────────┐ │ The location of the DAYO POS files (ie INVOICE.DBF) does not have to be │ │ in the same drive/directory as DAYO GL. If you have installed the │ │ DAYO POS Databases, into a different directory, you need to tell DAYO │ │ GL where to find them. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOPOS\ │ │ The drive designation is optional (if same as DAYO GL). │ │ │ │ Enter Location: \DAYOPOS\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ BACKORDERS (CUSTOMER'S) DATABASE LOCATION/DIRECTORY ┌──────────[ BACKORDERS (CUSTOMER'S) DATABASE LOCATION/DIRECTORY ]───────────┐ │ The location of the DAYO BackOrder database does not have to be │ │ in the same drive/directory as DAYO GL. If you have installed the │ │ DAYO BackOrder Database, into a different directory, you need to tell │ │ DAYO GL where to find it. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOBO\ │ │ The drive designation is optional (if same as DAYO GL). │ │ │ │ Enter Location: \DAYOBO\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ CUSTOMER (AR) DATABASE LOCATION/DIRECTORY ┌───────────────[ CUSTOMER (AR) DATABASE LOCATION/DIRECTORY ]────────────────┐ │ The location of the DAYO Customer and other AR databases does not have to b│ │ in the same drive/directory as DAYO GL. If you have installed the │ │ DAYO Customer/AR Databases, into a different directory, you need to tell │ │ DAYO General Ledger where to find them. Default is nil (current directory).│ │ Be sure to include the rightmost slash, ie: \DAYOAR\ │ │ The drive designation is optional (if same as DAYO GL). │ │ │ │ Enter Location: \DAYOAR\ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 95 ■ ACCOUNTS PAYABLE (AP) DATABASE LOCATION/DIRECTORY ┌───────────[ ACCOUNTS PAYABLE (AP) DATABASE LOCATION/DIRECTORY ]────────────┐ │ The location of the DAYO Accounts Payable databases does not have to be │ │ in the same drive/directory as DAYO GL. If you have installed the │ │ DAYO AP Databases, into a different directory, you need to tell DAYO GL │ │ where to find them. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOAP\ │ │ The drive designation is optional (if same as DAYO GL). │ │ │ │ Enter Location: \DAYOAP\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ PAYROLL DATABASE LOCATION/DIRECTORY ┌──────────────────[ PAYROLL DATABASE LOCATION/DIRECTORY ]───────────────────┐ │ The location of the DAYO Payroll databases does not have to be │ │ in the same drive/directory as DAYO GL. If you have installed the │ │ DAYO Payroll Databases, into a different directory, you need to tell │ │ DAYO GL where to find them. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOPAY\ │ │ The drive designation is optional (if same as DAYO GL). │ │ │ │ Enter Location: \DAYOPAY\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ ASSETS DATABASE LOCATION/DIRECTORY ┌───────────────────[ ASSETS DATABASE LOCATION/DIRECTORY ]───────────────────┐ │ The location of the DAYO Assets databases does not have to be │ │ in the same drive/directory as DAYO GL. If you have installed the │ │ DAYO Assets Databases, into a different directory, you need to tell │ │ DAYO GL where to find them. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOASS\ │ │ The drive designation is optional (if same as DAYO GL). │ │ │ │ Enter Location: \DAYOASS\ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 96 ■ MATERIALS REQUIREMENT PLANNING (MRP) DATABASE LOCATION/DIRECTORY ┌────[ MATERIALS REQUIREMENT PLANNING (MRP) DATABASE LOCATION/DIRECTORY ]────┐ │ The location of the DAYO MRP databases does not have to be │ │ in the same drive/directory as DAYO GL. If you have installed the │ │ DAYO MRP Databases, into a different directory, you need to tell │ │ DAYO GL where to find them. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOMRP\ │ │ The drive designation is optional (if same as DAYO GL). │ │ │ │ Enter Location: \DAYOMRP\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ END OF PERIOD - PHYSICAL INVENTORY DATABASE LOCATION/DIRECTORY ┌──────[ END OF PERIOD - PHYSICAL INVENTORY DATABASE LOCATION/DIRECTORY ]────┐ │ The location of the DAYO EOP databases (ie: PHYSICAL.DBF) does not have │ │ to be in the same drive/directory as DAYO GL. If you have installed │ │ DAYO EOP, into a different directory, you need to tell DAYO GL where to │ │ find it. Default is nil (current directory). │ │ Be sure to include the rightmost slash, ie: \DAYOEOP\ │ │ The drive designation is optional (if same as DAYO GL). │ │ │ │ Enter Location: \DAYOEOP\ │ └────────────────────────────────────────────────────────────────────────────┘ ■ LAST GL POSTING TRANSACTION NUMBER ┌───────────────────[ LAST GL POSTING TRANSACTION NUMBER ]───────────────────┐ │ This Control Number is incremented for each GL transaction created. │ │ The NEXT transaction number (TRANSACT) will be this number plus 1... │ │ * Note - This field is automatically reset at 999999. │ │ A transaction number is 12 characters long and consists of the date │ │ plus the transaction number, ie: 900101000001 │ │ └──┬─┘└──┬─┘ │ │ Date (Jan 1, 1990) ─────┘ │ │ │ Transaction Number ───────────┘ │ │ │ │ Enter 'Last' Transaction Number: 118 │ └────────────────────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 97 ■ SAVE PURGED TRANSACTIONS ┌─────────────────────────[ SAVE PURGED TRANSACTIONS ]───────────────────────┐ │ Because of the large volume of transactions, it is often necessary to purge│ │ transactions from old/past accounting periods. Use this option to │ │ permanently remove General Ledger transaction records from the database │ │ GLTRANS.DBF. │ │ │ │ Note, you have the option to save transactions into a history database │ │ called GLHIST.DBF. This option is set from the Configuration Menu. │ │ │ │ Current setting is to SAVE purged transactions. │ │ │ │ Do you wish to save your purged GL transaction records? (Y/N) * │ └────────────────────────────────────────────────────────────────────────────┘ ■ VIEW CHART OF ACCOUNTS ┌────────────────────────[ VIEW CHART OF ACCOUNTS ]──────────────────────────┐ │ When viewing the Chart of Accounts (option 1 from the Main Menu), you │ │ can view all Period & Budget information, or just some of the key fields. │ │ Default is not to show all the Period and Budget fields. │ │ │ │ Do you wish to view all Period & Budget information? (Y/N) │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ STOP GL POSTING AT WRONG CLASS CODE ┌──────────────────[ STOP GL POSTING AT WRONG CLASS CODE ]───────────────────┐ │ If this option is set to Y (Yes), the GL Posting will stop and prompt │ │ you to enter the correct CLASS Code. If set to N (No), the posting │ │ will skip (lease unposted) the record. │ │ Default is to stop and request correct CLASS Code. │ │ │ │ Do you wish to stop and correct CLASS Codes during the GL Post? (Y/N) │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 98 ■ DEPARTMENT CODE SETUP ┌─────────────────────────[ DEPARTMENT CODE SETUP ]──────────────────────────┐ │ This option defines the position (within the 12 digit GL Account │ │ number) at which the Department code starts/stops. The default is to │ │ start at position 3 and stop at position 5, ie: │ │ 10100-100000 │ │ Major Account ───┴┘│││ ││││││ │ │ Department ────────┴┴┘ └┴┴┴┴┴──── Sub Account │ │ │ │ Starting Position: 3 │ │ Ending Position: 5 │ └────────────────────────────────────────────────────────────────────────────┘ ■ REPORT PRINTER TYPE ┌──────────────────────────[ REPORT PRINTER TYPE ]───────────────────────────┐ │ Routine reports are printed according to this selection. │ │ The STANDARD printer type is a Epson/IBM Proprinter compatible printer. │ │ The LASER printer type is a Hewlett Packard Laser compatible printer. │ │ Special Laser codes are sent to the LASER option. │ │ │ │ Enter Your Report Printer Type -> STANDARD │ │ LASER │ └────────────────────────────────────────────────────────────────────────────┘ ■ REPORT PRINTER PORT ┌──────────────────────────[ REPORT PRINTER PORT ]───────────────────────────┐ │ Enter Your Report Printer Port (1,2,3): 1 │ └────────────────────────────────────────────────────────────────────────────┘ ■ VISUAL INDEXING ┌────────────────────────────[ VISUAL INDEXING ]─────────────────────────────┐ │ If you desire to see a progress graph each time your indexes are │ │ created, then select Y (YES). Note, the process can slow the indexing │ │ routine down; especially with larger databases. │ │ │ │ Do you wish to have Visual Indexing? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 99 ■ AUTOMATIC DAILY INDEXING ┌────────────────────────[ AUTOMATIC DAILY INDEXING ]────────────────────────┐ │ If this option is set to Y (YES), then all DAYO Indexes accessed by │ │ DAYO GL will be recreated once daily. This will occur when the first │ │ DAYO GL program is run. The default is to recreate all the indexes. │ │ │ │ Recreate all DAYO GL Indexes? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ COLOR MONITOR To activate a color change, you must completely exit DAYO GL, then reenter. ┌─────────────────────────────[ COLOR MONITOR ]──────────────────────────────┐ │ If you have a color monitor and wish to display colors, then select Y, │ │ (YES), else select N (NO) for monochrome and others. │ │ The default is color, low intensity │ │ │ │ Do you have a color monitor? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ ■ COLOR INTENSITY ┌────────────────────────────[ COLOR INTENSITY ]─────────────────────────────┐ │ Intensity is only applicable with color set to Y. │ │ It will make your colors brighter... │ │ │ │ Set Color Intensity On? (Y/N) │ └────────────────────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 100 ■ MISCELLANEOUS ROUTINES - The MISC routines is a collection of 17 very useful Database Management Routines. These routines provide you with the 'ability to do whatever was left out of the rest of the program...'. These routines were modeled after dBase (tm) III+/IV functions. Familiarity with dBase will help with the understanding and execution of these routines. USE WITH CAUTION! YOU CAN ENHANCE AND CUSTOMIZE YOUR PROGRAM WITH THESE ROUTINES YOU CAN ALSO MESS THINGS UP PERMANENTLY! ■ MISC ROUTINES MENU: DAYO GL Version 2.0 TJS LAB ┌───[February 1991]──┐ ╔════════════════════╗─╖ │S M T W T F S │ ║ MISC ROUTINES ║ ║ █▄██▄ ▄█▄ █░ █░ ▄███▄ ├────────────────────┤ ╟────────────────────╢─╢ █░ █░ █░█░ █░ █░ █░ █░ │ 1 2 3 4 5 6 7│ ║ APPEND FROM ║ ║ █░ █░ █░█░ ▀█░██░ █░ █░ │ 8 9 10 11 12 13 14│ ║ BROWSE DATABASES ║─╢ █░ █░ █▀▀▀█░ ▀█▀ █░ █░ │15 16 17 18 19 20 21│ ║ COPY (.DBF) TO ║ ║ █░ █░ █░ █░ █░ █░ █░ │22 23 24 25 26 27 28│ ║ CREATE DATABASE ║─╢ █▀██▀ █░ █░ █░ ▀███▀ │29 30 │ ║ DELETE RECORDS ║ ║ │ │ ║ ERASE FILE ║─╢ └────────────────────┘ ║ EXIT TO DOS ║ ║ ║ INDEX A DATABASE ║─╢ ████░ █░ █░ █▄██▄ ▄███▄ ████░ ║ LIST FIELDS ║ ║ █░ ██░ █░ █░ █░ █░ █░ █░ ║ PACK DATABASE ║─╢ ███░ ███░█░ █░ █░ █░ █░ ████░ ║ MODIFY DATABASE ║ ║ █░ █▀███░ █░ █░ █░ █░ █░ ║ RECALL RECORDS ║─╢ █░ █░▀██░ █░ █░ █░ █░ █░ ║ RETURN TO MENU ║ ║ ████░ █░ ▀█░ █▀██▀ ▀███▀ █░ ║ RUN (DOS COMMAND) ║═╝ ║ SIMPLE EDITOR ║04/01/90 █▄██▄ ████░ █▄███░ ███░ ▄███▄ █▄██▄ ║ SORT DATABASE ║12:06:53 █░ █░ █░ █░ █░ █░ █░ █░ █░ █░ ║ TYPE (PRINT) FILE ║1 █░ █░ ███░ █▄▄▄█░ █░ █░ █░ █░ █░ ║ ZAP DATABASE ║3 █▀██▀ █░ █▀█▄ █░ █░ █░ █░ █░ ╟────────────────────╢3.00 █░ █░ █░ ▀█░ █░ █░ █░ █░ █░ ║ Select Option ║TLJ █░ ████░ █░ █░ ███░ ▀███▀ █▀██▀ ╚════════════════════╝ DAYO GL, TJS LAB Page: 101 ■ APPEND FROM - Used to copy records from one database into another database, or to create records from ASCII files (SDF or DELIMITED). - The Initial Screen will prompt you to enter the file name of the database you are to append/copy the data into. At this point, you can either type in the name of the target database, or ... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ └────────────────────────────────────────────────────────────────────────────┘ - If it exists in the current directory, press enter on an empty prompt to display all databases to select from. ┌──────────────────────────────[ APPEND FROM ]──────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │INVENT.DBF │ 375 │ 09/16/89 │ │ │ │AR.DBF │ 7219 │ 09/16/89 │ │ │ │HISTORY.DBF │ 103 │ 09/16/89 │ │ │ │PERSONS.DBF │ 24271 │ 09/16/89 │ │ │ │CUSTOMER.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ │ │ └───────────────────────────────────────────────────────────────────────────┘ - The next prompt will be to select the type of Append: ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ └──────────────────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 102 - If you are appending from another database (.DBF) then select 'Standard'. - Select the SDF option if you are appending from a 'flat' ASCII file. - Select the DELIMITED option if you are appending from a delimited ASCII file. Delimited files contain records in which the fields are separated by commas, and its character fields contained in double quotes... - If you select a Standard Append, you will then be prompted to enter the name of the database you wish to get the data from. If you selected the SDF or DELIMITED options, then enter the file name containing the data to be appended into your target database. ┌──────────────────────────────[ APPEND FROM ]─────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into PERSONS.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: PERSON1.TXT │ │ │ │ │ └──────────────────────────────────────────────────────────────────────────┘ - The number of records appended into the target database will be displayed upon completion of the task... ┌──────────────────────────────[ APPEND FROM ]───────────────────────────────┐ │ │ │ Enter Database Name To Append Data Into: │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ Append Data Into INVENT.DBF From INVENTY.DBF │ │ │ │ Type of Append: Standard SDF DELIMITED │ │ │ │ Enter Database Name To Append Data FROM: INVENT.DBF │ │ │ │ │ │ │ │ There Were 1 Records Appended Into INVENT.DBF │ │ │ │ │ │ │ │ Press Any Key To Continue... │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 103 ■ BROWSE DATABASES - Used to edit/view records in a database. Enter the database name you wish to edit/browse, or if it exists in the current directory, press enter on an empty prompt to bring up a window box to select from. ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: INVENT.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ - If there exists an index (.NDX or .NTX), with the same name as the database, it will be utilized... The DAYO Inventory indexes are the exception. They are automatically set/used. - An example of a browse screen: TJS LAB, PO BOX 585366 ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ MFG_PART DESC PRICE LIST │ │──────────────────╥────────────────────────────────╥────────────╥───────────│ │ 19730 ║ DAYO CONFIGURATION SETTINGS ║ 896.16 ║ 1792.32 │ │ 23429 ║ DAYO CUSTOMER ║ 1064.19 ║ 2128.38 │ │ 14797 ║ DAYO END OF PERIOD/DAY ║ 672.12 ║ 1344.24 │ │ 38227 ║ DAYO FINANCE,PERSONNEL,PAYROLL ║ 1736.31 ║ 3472.62 │ │ 11098 ║ DAYO INVENTORY ║ 504.09 ║ 1008.18 │ │ 17264 ║ DAYO MISC ROUTINES ║ 784.14 ║ 1568.28 │ │ 30828 ║ DAYO PICK, INVOICING ║ 1400.25 ║ 2800.50 │ │ 35760 ║ DAYO PURCHASE ORDERS ║ 1624.29 ║ 3248.58 │ │ 25896 ║ DAYO QUOTES ║ 1176.21 ║ 2352.42 │ │ 62889 ║ DAYO ROPA ║ 2856.51 ║ 5713.02 │ │ 64122 ║ DAYO ROPA/ROPC SOURCE ║ 2912.52 ║ 5825.04 │ │ 28362 ║ DAYO SALES ORDERS, P.O.S. ║ 1288.23 ║ 2576.46 │ │ 33294 ║ DAYO VENDORS ║ 1512.27 ║ 3024.54 │ │ 66588 ║ DBASE TRAINING (PER HOUR) ║ 3024.54 ║ 6049.08 │ │ 16031 ║ EOP SOURCE ║ 728.13 ║ 1456.26 │ │ 49325 ║ EXPENSES SOURCE ║ 2240.40 ║ 4480.80 │ │ 39460 ║ FINANCE SOURCE ║ 1792.32 ║ 3584.64 │ ├──────────────────╨────────────────────────────────╨────────────╨───────────┤ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ 51/60 DAYO GL, TJS LAB Page: 104 - To edit a memo field, just highlight the field, and start typing. * * * To save your work, once finished, YOU MUST PRESS Ctrl W UPON EXITING! ┌────────────────────────────────[ BROWSE SDF ]──────────────────────────────┐ │ PRICE LIST YOURPART NOTES │ │───────────────────────╥────────────╥─────────────────╥─────────────────────│ │ 896.16 ║ 1792.32 ║ ║ <Memo> │ │ 1064.19 ║ 2128.38 ║ ║ <Memo> │ │ 672.12 ║ 1344.24 ║ ║ <Memo> │ │ 1736.31 ║ 3472.62 ║ ║ <Memo> │ │ 504.09 ║ 1008.18 ║ ║ <Memo> │ │ 784.14 ║ 1568.28 ║ ║ <Memo> │ │ 1400.25 ║ 2800.50 ║ ║ <Memo> │ ┌────────────────────────────[ Edit Field: NOTES ] ──────────────────────────┐ │You can edit memo fields too... │ │ │ │ │ │ │ │ │ │ │ │ │ └───────────────────────[ Esc (ABORT) Ctrl W (SAVE) ]─────────────────────┘ │ Esc(EXIT) Ctrl N(ADD) Ctrl U(DELETE) F5(Find) │ └────────────────────────────────────────────────────────────────────────────┘ - Special keys for 'moving around' the BROWSE screen are: Left Arrow Key - Move to next field to your left Right Arrow Key - Move to next field to your right Ctrl Home - Go to the leftmost field Ctrl End - Go to the rightmost field (on the end of the record) Up Arrow - Move highlight to the previous record Down Arrow - Move highlight to the next record PgUp - Page up a full screen of records PgDn - Page down a full screen of records Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end or last record of the file Ctrl N - Add a record (where applicable) Ctrl U - Delete a record (where applicable) F5 - To seek/find a record based upon the active index Esc - Exit the current operation - Remember that there are many more fields to the right of the screen. Press the right arrow key to view them... DAYO GL, TJS LAB Page: 105 ■ COPY (.DBF) TO - Copy records to another (new) database. Use this option to copy select records into a new database or ASCII (SDF and DELIMITED) file. COPY TO can also be used to create backups of data (EG: copy to floppy). ┌─────────────────────────────[ COPY (.DBF) TO ]─────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: │ │ Enter┌────────[ PICK A DATABASE ]───────────┐y... │ │ │ FILE NAME SIZE DATE USED│ │ │ ├──────────────┬────────────┬──────────┤ │ │ │HARPS.DBF │ 375 │ 09/16/89 │ │ │ │INVENT.DBF │ 7335 │ 09/16/89 │ │ │ │SDFSTUF.DBF │ 103 │ 09/16/89 │ │ │ │MORETRAH.DBF │ 24387 │ 09/16/89 │ │ │ │AP.DBF │ 289 │ 09/16/89 │ │ │ └──────────────┴────────────┴──────────┘ │ │ ┌───────────────────────┐│ │ │ Highlight a database ││ │ │ using the ││ │ │ arrow keys, then press││ │ │ Enter/Return. ││ │ └───────────────────────┘│ └────────────────────────────────────────────────────────────────────────────┘ - The next prompt will be to select the type of COPY TO option you want: ┌──────────────────────────────[ COPY (.DBF) TO ]────────────────────────────┐ │ │ │ Enter Database Name To COPY FROM: INVENT.DBF │ │ Enter Nothing For Listing Of Current Directory... │ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ │ │ Copy Records From INVENT.DBF │ └────────────────────────────────────────────────────────────────────────────┘ - The Standard option is simply creating another database (.DBF). The SDF and DELIMITED options will create ASCII files. The STRUCTURE option creates a new database with the same file structure as the initial database (no records copied). DAYO GL, TJS LAB Page: 106 - The next prompt (optional), requires some knowledge of dBase (tm). This prompt is requesting the user to to enter a condition or filter. If all records are to be copied, just press Enter on an empty prompt. ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW.DBF │ │ │ │ Enter Condition: │ │ Sample condition: COST > 100 │ │ │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ - This 'Condition' option is useful for coping only specific records into a new location. Any valid dBase/Clipper statement (as shown next) is fine... ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW DBF │ │ │ │ Enter Condition: PRICE>0 │ │ Sample condition: COST > 100 │ │ │ │ Copy Records From NEW │ └────────────────────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 107 - The following window message will appear while the COPY TO routine does its task: ┌╔═══════════════════════════[ FIELD NAMES & TYPE ]═════════════════════════╗┐ │║ ║│ │║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║│ │║NOTES{M} ■ ║│ │╚══════════════════════════════════════════════════════════════════════════╝│ │ │ │ Type of Copy To: Standard SDF DELIMITED STRUCTURE │ │ │ │ Enter SDF File Name To Copy Data TO: NEW10 │ │ │ │ Enter Condition: PRICE>0 │ │ Sample cond┌───────────────────────────────────────────────┐ │ │ │┌─────────────────────────────────────────────┐│ │ │ CONDITION: ││┌───────────────────────────────────────────┐││ │ │ │││┌─────────────────────────────────────────┐│││ │ │ ││││Hold those camels while I do this COPY TO││││ │ │ │││└─────────────────────────────────────────┘│││ │ │ ││└───────────────────────────────────────────┘││ │ │ │└─────────────────────────────────────────────┘│ │ │ └───────────────────────────────────────────────┘ │ │ Copy Records From SDF To NEW10 │ └────────────────────────────────────────────────────────────────────────────┘ ■ CREATE DATABASE - Create a new database. This routine lets you create entirely new database structures. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ ║ ║ 0 ║ 0 │ │ ║ ║ ║ │ │ ║ ║ ║ │ ┌─────────────│ ║ ║ ║ │────────────┐ │ │ ║ ║ ║ │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ DAYO GL, TJS LAB Page: 108 * * * TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST * * * IT IS SLIGHTLY BOTHERSOME SORRY! WANT YOU TO THINK ABOUT WHAT YOU ARE DOING... *** If any error is made in this routine, you will experience an error, either immediately, or when you start to edit the new database. This error may even cause your computer to hang! *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ┌───────[ CREATE A NEW DATABASE: NEW.DBF ]────────┐ │ FIELD_NAME FIELD_TYPE FIELD_LEN FIELD_DEC │ │────────────╥────────────╥───────────╥───────────│ │ NAME ║ C ║ 30 ║ 0 │ │ AGE ║ N ║ 5 ║ 1 │ │ DEAD ║ L ║ 1 ║ 0 │ │ BIRTHDATE ║ D ║ 8 ║ 0 │ ┌─────────────│ REMARKS ║ M ║ 10 ║ 0 │────────────┐ │ │ ║ ║ 0 ║ 0 │ │ │ ENTER TH│ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ │ │ ║ ║ ║ │ │ └─────────────│ ║ ║ ║ │────────────┘ │ ║ ║ ║ │ │────────────╨────────────╨───────────╨───────────│ │ Press Enter to edit any field... │ └──────[ PRESS Ctrl W TO SAVE AND EXIT ]────────┘ DAYO GL, TJS LAB Page: 109 ■ DELETE RECORDS - Delete selected records from databases. The first prompt is for the name of the database you wish to mark records for deletion. Like many of the other routines, you can press enter on an empty prompt to bring up all databases that exist in the current directory: ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │D.DBF │ 259 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/16/89 │ │XXX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌────────────────────────[ DELETE SELECTED RECORDS ]│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └────────────────────────────────────────────────────────────────────────────┘ - After selecting the database, all its fields will be presented atop the screen so as to aid the user in entering a condition/filter. The use of the condition prompt is NOT optional, so some knowledge of dBase/Clipper syntax is required. Note the use of the Clipper Function: EMPTY(). ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌────────────────────────[ DELETE SELECTED RECORDS ]─────────────────────────┐ │ Enter Database Name: TRASH │ │ Delete Records For Condition: EMPTY(PART) │ │ Sample condition: COST > 100 │ │ CONDITION: EMPTY(PART) │ │ Number of Records Deleted: 208 │ │ Press any key to continue... │ └────────────────────────────────────────────────────────────────────────────┘ - The number of records deleted will be displayed upon the screen as depicted just above... DAYO GL, TJS LAB Page: 110 ■ ERASE FILE - Erase a file (forever!). Use this option with extreme care! Again, be careful! ANY FILE SELECTED WITH THIS OPTION WILL BE PERMANENTLY REMOVED FROM EXISTENCE NO SECOND CHANCES HERE... - The first prompt is for the file name. You can press enter on an empty prompt to bring up a window selection of all files in the current directory. ┌────────────────────────┐ ┌────────[ ERASE THE FILE ]────────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.$$$ │ 8192 │ 09/16/89 │ └────────────────────────┘ │BKDOOR.DOC │ 37029 │ 09/17/89 │ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │D.DBF │ 259 │ 09/16/89 │ │D.DBT │ 512 │ 09/16/89 │ │DAYOBK.BAK │ 36879 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ │DAYOBK.OBJ │ 35585 │ 09/16/89 │ │DAYOCAL.MAP │ 35 │ 09/16/89 │ │DDD.DBF │ 375 │ 09/16/89 │ │DDD.DBT │ 512 │ 09/16/89 │ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More - To ERASE a file, just highlight it, then press Enter... ■ EXIT TO DOS - This option will close all open files and databases and exit to DOS without having to return to the main menu exit routine. DAYO GL, TJS LAB Page: 111 ■ INDEX A DATABASE - You will be prompted to select the database you wish to index. After selecting the database, by typing in the name or pressing Enter on an empty prompt (then selecting from the window), you will be given a listing of all fields in that database atop the screen. ┌────────[ PICK A DATABASE ]───────────┐. │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DAD.DBF │ 259 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SPW.DBF │ 7335 │ 09/16/89 │ │SOW.DBF │ 103 │ 09/16/89 │ │BOY.DBF │ 24387 │ 09/17/89 │ │SHI.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ INDEX A DATABASE ]───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ - You will now be prompted to enter the name of the Index File. It will be (by default), named exactly the same as the selected database, with the exception of the extension. This will default to .NDX or .NTX depending on whether you linked NDX.OBJ with your application. *** Remember that the BROWSE routine only looks at indexes with the same name as the database. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ └───────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 112 - At the prompt for the index key, enter a field name, or a valid dBase/Clipper expression. ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ INDEX A DATABASE ]────────────────────────┐ │ Enter Name of Index File: TRASH.NTX │ │ Enter the Key Expression: PART+MFG_PART │ └───────────────────────────────────────────────────────────────┘ ■ LIST FIELDS - List fields to screen or printer. This routine is a great tool for providing simple reports and lists. The first prompt will be for the database you wish to work with. Type the name of the file, or press Enter on an empty prompt to bring up a window of all databases in the current directory for selection. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │INVEND.DBF │ 259 │ 09/16/89 │ │INVENT.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SOMEDAY.DBF │ 7335 │ 09/16/89 │ │TANGO.DBF │ 103 │ 09/16/89 │ │AP.DBF │ 24387 │ 09/17/89 │ │BACKUP.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ └───────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 113 - The next prompt is for a condition or filter. This makes it possible to list only specific records that meet that condition you enter. The condition must be a valid dBase/Clipper expression, or none (to list all). ╒╔══════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌─────────────────────────────────────────────────────┐ │ Enter Filter: │ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ └─────────────────────────────────────────────────────┘ ┌───────────────────────────────────────────────────────────────┐ │ Enter Database Name: │ │ │ └───────────────────────────────────────────────────────────────┘ - A window box appears next displaying all the fields in the selected database and an option to list all fields. Highlight any combination of fields ( or ALL) that you want listed. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║ ├─────────────────┤ ║ ╚═│■■ ALL ■■ │═══════════════════════════════════════════════════════╝ │RECNO() │ │MFG_PART │ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 114 - The fields you select will be displayed at center top of screen. Press Esc to exit the "PICK THE FIELDS YOU WANT LISTED" window. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │PRICE │ │YOURPART │ ┌────────────────────────────────────────────────────┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ - At the next prompt, you can send the list to the SCREEN, PRINTER OR FILE. ╒╔═┌─────────────────┐═══════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ │ PICK THE FIELDS │ ║ ╘║P│ YOU WANT LISTED │} ■ DES┌────────────────────┐{N} ■ YOURPART{C} ■ ║ ║N├─────────────────┤ │PART │ ║ ╚═│■■ ALL ■■ │═══════│MFG_PART │══════════════════════════╝ │RECNO() │ │PRICE │ │PART │ └────────────────────┘ │DESC┌──────────────────────────────────────────────────────────────────┐ │PRIC│ Do you want to print the list to the SCREEN or PAPER or FILE ? │ │LIST│ │ │YOUR└──────────────────────────────────────────────────────────────────┘─┐ │NOTES │ │ Enter Filter: │ ├─────────────────┤ │ EG: ID = "SAM0909" .AND. RETAIL > 10000 │ │PRESS Esc TO EXIT│ └────────────────────────────────────────────────────┘ └─────────────────┘────────────────────────────────────────────────────┐ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 115 - The list is very simple, and if displayed onto the screen, may look like the following: PART MFG_PART PRICE 4523 0.00 DAYO9S 41926 1904.34 DAYO10S 13564 616.11 DAYOCOMP 45625 2072.37 DAYOALLS 43159 1960.35 INDEXER 50558 2296.41 INDEXERS 51791 2352.42 5 DEMO 4932 224.04 DAYO13S 20963 952.17 MENUS 53024 2408.43 OFFSITEP 56724 2576.46 ONSITEP 57957 2632.47 DAYO2S 24662 1120.20 DAYO9 40693 1848.33 DAYO10 12331 560.10 DAYOCAL$ 44392 2016.36 DAYO13 19730 896.16 DAYO2 23429 1064.19 DAYO11 14797 672.12 DAYO8 38227 1736.31 DAYO1 11098 504.09 DAYO12 17264 784.14 DAYO5 30828 1400.25 ......PRESS ANY KEY TO CONTINUE...... ■ MODIFY DATABASE - Change the fields/structure of a database. You can add new fields, delete fields, change the length and type of field in any of the databases. At the FIELD_NAME field, enter a unique field name. At the FIELD_TYPE field, enter a 'C' for character, 'N' for numeric, 'D' for Date, 'L' for logical or 'M' for memofield. At the FIELD_LEN field, enter the size/length of the character and/or numeric field. At the FIELD_DEC field, enter the number of decimals for the numeric field. ******************************************************** *** TO EDIT ANY FIELD, YOU MUST PRESS Enter FIRST *** *** IT IS SLIGHTLY BOTHERSOME SORRY! *** ******************************************************** *** If any error is made in this routine, you will experience an error, either immediately, or when you start to access the database. This error may even cause your computer to hang! DAYO GL, TJS LAB Page: 116 *** Be sure to Press: Ctrl W when you are finished and satisfied. Pressing Esc will just negate your efforts.. ■ PACK DATABASE - Pack a database (removed deleted records). This option will permanently remove any records marked for deletion. This is another routine you should use with great care! As in many of the other of the routines, you will be prompted to enter the name of the database you wish to pack. Enter the name or press Enter on an empty prompt to view the window. ┌─────┐ │PACK!│ └─────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │GOODDATA.DBF │ 259 │ 09/16/89 │ │HAP.DBF │ 375 │ 09/16/89 │ │NEW.DBF │ 195 │ 09/17/89 │ │SDF.DBF │ 7335 │ 09/16/89 │ │LOIN.DBF │ 103 │ 09/16/89 │ │TRASH.DBF │ 24387 │ 09/17/89 │ │FIX.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌──────────────────────────────────────────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ - After selecting the database, you will be prompted to respond with a Yes or No (to Pack or not to Pack...). This is the last chance you have to change your mind... ┌──────────────────────────────────────────────────────────────────────────┐ │ PACK TOM3 │ │ Are you sure you want to PACK (remove deleted records) ? N │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 117 ■ RECALL RECORDS - Recalls records previously marked for deletion. This option is identical to the DELETE RECORDS option discussed earlier... ■ RETURN TO MENU - Returns to the procedure that called MISC Routines. ■ RUN (DOS COMMAND) - Run a DOS command (EG: dir/w). This option is helpful in that it allows you to run programs at the DOS level (within memory constraints). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN CD\DOS │ └───────────────────────────────────────────────────────────────────────────┘ - One useful option is to type and Enter: COMMAND at this prompt. You will be running another DOS Shell totally out of the program (it still is in memory though). ┌───────────────────────────────────────────────────────────────────────────┐ │ RUN COMMAND │ └───────────────────────────────────────────────────────────────────────────┘ - Press and Enter: EXIT to return to your Clipper Application. EG: The COMPAQ Personal Computer MS-DOS Version 3.31 (C) Copyright Compaq Computer Corp. 1982, 1987 (C) Copyright Microsoft Corp. 1981, 1987 C:\KISBBS>EXIT DAYO GL, TJS LAB Page: 118 ■ SIMPLE EDITOR - A simple editor and word processor. Use this option to create and read simple TEXT files. File size is limited to your machines capabilities or 32,000k. The first prompt is for the name of the file you wish to edit. Type in the name, or press Enter on an empty prompt to bring up a window option box containing all files in the current directory. ┌────────────────────────┐ ┌──────────[ EDIT THE FILE ]───────────┐ │ Highlight a file │ │ FILE NAME SIZE DATE USED│ │ using the │ ├──────────────┬────────────┬──────────┤ │ arrow keys, then press │ │B.BAT │ 222 │ 09/16/89 │ │ Enter/Return. │ │BKDOOR.DOC │ 56356 │ 09/17/89 │ └────────────────────────┘ │BKDOOR.ZIP │ 19415 │ 09/16/89 │ │DAYOBK.LIB │ 36879 │ 09/16/89 │ │DAYOBK.LST │ 2056 │ 09/16/89 │ ┌────────│DAYOBK.OBJ │ 35585 │ 09/16/89 │────────────────────────────┐ │ Enter t│DAYOCAL.MAP │ 35 │ 09/16/89 │ │ │ Press E│DDD.DBF │ 375 │ 09/16/89 │urrent directory listing. │ └────────│DDD.DBT │ 512 │ 09/16/89 │────────────────────────────┘ │DDD.NTX │ 2048 │ 09/16/89 │ │DEMO.EXE │ 245404 │ 09/16/89 │ │DEMO.MAP │ 7780 │ 09/16/89 │ └──────────────┴────────────┴──────────┘ More - *** Note, this routine will try to load binary files (.EXE, .OBJ, .etc...), so be careful at what you select for viewing/editing. - If you make ANY changes to the file, You MUST PRESS Ctrl W to SAVE those changes. If you exit with an Esc, all changes will be lost! ┌──────────────────────────────[ SIMPLE EDITOR ]─────────────────────────────┐ │CLIPPER demo │ │CLIPPER MISC │ │KWAIT 10 │ │LIB MISC-+MISC,MISC.LST,MISC │ │KWAIT 10 │ │TLINK DEMO,,,MISC \CLIPPER\CLIPPER \CLIPPER\EXTEND │ │KWAIT 10 │ │DEMO │ └────────────────────────────────────────────────────────────────────────────┘ Esc (ABORT) Ctrl W (SAVE) Initial Size: 222 1/0 DAYO GL, TJS LAB Page: 119 - Special keys for 'moving around' the SIMPLE EDITOR screen are: Left Arrow Key - Move to your left Right Arrow Key - Move to your right Ctrl Home - Go to the top, leftmost corner of window Ctrl End - Go to the bottom, rightmost corner of window Up Arrow - Move up one line Down Arrow - Move down one line PgUp - Page up a full screen PgDn - Page down a full screen Ctrl PgUp - Go to the beginning of the file Ctrl PgDn - Go to the end of the file * F2 - Import text from a text file * Ctrl W - Save Changes and Exit * Esc - ABORT Changes and Exit The margin may exceed the boundaries on the right side of the screen, but the text is easily accessed using the special keys above... ■ SORT DATABASE - This option takes a database, sorts it, and copies the result into a new database. The first prompt is for the name of the database you want to sort. Enter the name, or press Enter on an empty prompt to bring up a window box containing all databases in the current directory. ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DOG.DBF │ 259 │ 09/16/89 │ │CAT.DBF │ 375 │ 09/16/89 │ │CAR.DBF │ 195 │ 09/17/89 │ │BAM.DBF │ 7335 │ 09/16/89 │ │HARP.DBF │ 103 │ 09/17/89 │ │TRAIN.DBF │ 24387 │ 09/17/89 │ │HIPPY.DBF │ 289 │ 09/16/89 │ ┌────────────────────────┐ └──────────────┴────────────┴──────────┘ │ Highlight a database │ │ using the │ ┌───────────────────[ SORT A DATABASE ]────│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ │ └────────────────────────┘ │ │ └───────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 120 - The next prompt is for the name of the database you will be creating with the sorted data. ╒╔═══════════════════════════[ FIELD NAMES & TYPE ]══════════════════════════╗ │║ ║ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚═══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: INVNET.DBF │ │ Enter Name of Sorted File: INVNET1.DBF │ │ │ └───────────────────────────────────────────────────────────────┘ - The next prompt is for the sort field (limited to 1 field)... ╒╔═════════════════════════[ FIELD NAMES & TYPE ]═══════════════════════════╗ ╘║PART{C} ■ MFG_PART{C} ■ DESC{C} ■ PRICE{N} ■ LIST{N} ■ YOURPART{C} ■ ║ ║NOTES{M} ■ ║ ╚══════════════════════════════════════════════════════════════════════════╝ ┌───────────────────[ SORT A DATABASE ]─────────────────────────┐ │ Enter Database Name: TOM.DBF │ │ Enter Name of Sorted File: TOM1.DBF │ │ Enter the Key Expression: PART │ └───────────────────────────────────────────────────────────────┘ ■ TYPE (PRINT) FILE - Prints an ASCII/text file to screen or printer. The first prompt is for the file name. ┌───────────────────────[ TYPE TO SCREEN OR PRINTER ]────────────────────────┐ │ Enter the ASCII/TEXT file to TYPE: KISBBS.DOC │ │ Press Enter/Return on an empty field to get a current directory listing. │ └────────────────────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 121 - The display of the file (any type), is continuous, but can be paused by any key (except the Enter & Esc keys). Pressing the Enter key will slow the printing of the file onto the screen. Press Esc to Abort the display... A sample display: FUNCKEY...........MISC FUNIQUE...........MISC FZAP..............MISC GET_PIC1..........MISC ISDATA............MISC ISDBF.............MISC MENU_KEY..........MISC MISC..............MISC OKFILE............MISC PACKIT............MISC PICKDBF...........MISC PROCLIST..........MISC SHOW_INS2.........MISC STATLINE2.........MISC TOG_INS2..........MISC XKEY_CLEAR........MISC XKEY_NORM.........MISC XMEMO.............MISC MISC BKDOOR BROWSEIT CENTER1 COLORSET DBFUNCT DBFUNCT6 EDITOR FACHOICE FAPPEND FCOPY2 FDBF1 FDELETE FERASE FILESZ FILE_UDF FILT FINDER FINDEX FMAKEDB FMODYDB FNEW FRECALL FRUN FSCROLL1 FSORT FTYPEIT FUNCKEY FUNIQUE FZAP GET_PIC1 ISDATA ISDBF MENU_KEY MISC OKFILE PACKIT PICKDBF PROCLIST SHOW_INS2 STATLINE2 TOG_INS2 XKEY_CLEAR XKEY_NORM XMEMO PRESS ANY KEY TO CONTINUE... ■ ZAP DATABASE - Totally erase all records in database (forever!). When you want to remove every record from a database, then use this option. Use with EXTREME CAUTION! The first prompt is for the file name. Enter the name of the database you are to 'clean out', or press Enter to select the database from a window containing all databases in the current directory. DAYO GL, TJS LAB Page: 122 ┌────┐ │ZAP!│ └────┘ ┌────────[ PICK A DATABASE ]───────────┐ │ FILE NAME SIZE DATE USED│ ├──────────────┬────────────┬──────────┤ │DENVER.DBF │ 259 │ 09/16/89 │ │OHIO.DBF │ 375 │ 09/16/89 │ │NEWYORK.DBF │ 195 │ 09/17/89 │ │MONTANA.DBF │ 7335 │ 09/16/89 │ │SC.DBF │ 259 │ 09/17/89 │ │EARS.DBF │ 103 │ 09/17/89 │ │FRUIT.DBF │ 24387 │ 09/17/89 │ ┌────────────────────────┐ │MATH.DBF │ 259 │ 09/17/89 │ │ Highlight a database │ │CARROTS.DBF │ 289 │ 09/16/89 │ │ using the │ └──────────────┴────────────┴──────────┘───│ arrow keys, then press │ │ Enter Database Name: │ Enter/Return. │ └──────────────────────────────────────────└────────────────────────┘ - You will be prompted one last time as to whether you still want to ZAP the selected database. Press Y for Yes, N for No... ┌────┐ │ZAP!│ └────┘ ┌──────────────────────────────────────────────────────────────────────────┐ │ ZAP TRASH │ │ Are you sure you want to ZAP (remove all records permanently) ? N │ │ │ └──────────────────────────────────────────────────────────────────────────┘ │ Enter Database Name: │ └───────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 123 ■ HELP SCREENS - While in the browse screens, some of the option windows, and in the SIMPLE EDITOR, pressing the F1 key, will display a help screen. - BROWSE help: ┌───────────────────────[ DAYOGL HELP: DBEDIT, 0, ]─────────────────────────┐ │ │ │- Special keys for 'moving around' the BROWSE screen are: │ │ │ │ Left Arrow Key - Move to next field to your left │ │ Right Arrow Key - Move to next field to your right │ │ Ctrl Home - Go to the leftmost field │ │ Ctrl End - Go to the rightmost field (on the end of the record)│ │ Up Arrow - Move highlight to the previous record │ │ Down Arrow - Move highlight to the next record │ │ PgUp - Page up a full screen of records │ │ PgDn - Page down a full screen of records │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end or last record of the file │ │ Ctrl N - Add a record (where applicable) │ │ Ctrl U - Delete a record (where applicable) │ │ F5,F6,F7 - To seek/find a record based upon the active index │ │ Esc - Exit the current operation │ │ │ │ Remember that there are many more fields to the right of the screen. │ │ Press the right arrow key to view them... │ └────────────────────────────────────────────────────────────────────────────┘ - Option Box Help: ┌────────────────────────[ DAYOGL HELP: ACHOICE, 0, ]───────────────────────┐ │ │ │ │ │ │ │ │ │ - Special keys for 'moving around' the Option Box are: │ │ │ │ Up Arrow - Move up one option │ │ Down Arrow - Move down one option │ │ PgUp - Page up multiple records │ │ PgDn - Page down multiple records │ │ Esc - ABORT and Exit │ │ │ │ │ │ After highlighting the option you desire, press Enter... │ │ │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ DAYO GL, TJS LAB Page: 124 - Editor help: ┌───────────────────────[ DAYOGL HELP: MEMOEDIT, 0, ]───────────────────────┐ │ │ │ - Special keys for 'moving around' the EDITOR screen are: │ │ │ │ Left Arrow Key - Move to your left │ │ Right Arrow Key - Move to your right │ │ Ctrl Home - Go to the top, leftmost corner of window │ │ Ctrl End - Go to the bottom, rightmost corner of window │ │ Up Arrow - Move up one line │ │ Down Arrow - Move down one line │ │ PgUp - Page up a full screen │ │ PgDn - Page down a full screen │ │ Ctrl PgUp - Go to the beginning of the file │ │ Ctrl PgDn - Go to the end of the file │ │ Ctrl W - SAVE Changes and Exit │ │ Esc - ABORT Changes and Exit │ │ F2 - Import another text file into your document │ │ │ │ The margin may exceed the boundaries on the right side of the screen, │ │ but the text is easily accessed using the special keys above... │ │ │ │ │ └────────────────────────────────────────────────────────────────────────────┘ ■ EXPANDED HELP After Version 1.3, expanded help routines were added to all DAYO modules. At almost all prompts and menus you can press F1 for help. Help can be a function key message as displayed on previous page, a message that you have created (user defined & inputted), or the ability to read the documentation on the screen (saves paper). DAYO GL, TJS LAB Page: 125 ■ USER DEFINED & INPUTTED HELP SCREENS/MESSAGES If you press F1 and no user defined & inputted message exists for that section of the program you are currently in you will receive a message to this effect, and then a blank/empty screen. The editing keys for this option are the same as for the Simple Editor (previous page). DAYO GL Version 2.0 TJS LAB ┌───[February 1991]──┐ ┌──────[ DAYO HELP Called by Program: DAYOGL Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ │ │ │ │ ╔════════════════════════════════════════════════════════╗ │ │ ║ No Online Help Messages Exist for this prompt... ║ │ │ ║ ║ │ │ ║ You can type in any help message you wish, or ║ │ │ ║ press F1 to view the document for DAYOGL. ║ │ │ ║ ║ │ │ ║ ║ │ │ ║ Press any key to continue... ║ │ │ ╚════════════════════════════════════════════════════════╝ │ │ │ │ │ ├───────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) │ └───────────────────────────────────────────────────────────────────────────┘ If you wish to input anything at this point, just type whatever you wish, remembering to press Ctrl W to save all changes. Pressing Esc will not save ANY changes ( all effort you put into writing a help message will be lost! ). DAYO GL, TJS LAB Page: 126 DAYO GL Version 2.0 TJS LAB ┌───[February 1991]──┐ ┌───────[ DAYO HELP Called by Program: DAYOGL Variable: OPT ]───────┐ │ │ │ │ │ │ │ │ │ Type in anything you wish about this portion of the program! │ │ │ │ The length of this file can be many pages... │ │ │ │ Be sure to press Ctrl W to save any changes/additions you make to this │ │ screen. │ │ │ │ │ │ │ │ │ │ │ │ │ ├────────────────────────────────────────────────────────────────────────────┤ │ Esc (Exit) Ctrl W (Save Changes) F1 (Read Manual) 13/4 │ └────────────────────────────────────────────────────────────────────────────┘ ■ VIEW DOCUMENTATION ONSCREEN To view the documentation for the module you are in, it must first exist in the current directory. Document files are named the same as the module, and have the extension of '.DOC', ie: DAYOINV.DOC, DAYOPOS.DOC, DAYOPAY.DOC. Press F1 in the User Defined & Inputted Help Message screen to display the document (user manual). The special keys in this option are displayed in the Help Screen (press F1 again) for this option: ╔══════════════════════════════════════════════════════════════════════════╗ ║ While viewing the document for DAYOGL the keyboard is configured ║ ║ as followed: ║ ║ ║ ║ Esc Exit ║ ║ F5 Find a string. This search is not case sensitive ║ ║ Examples: PAGE 50 ║ ║ INTRODUCTION ║ ║ REPORTS ║ ║ Home Return to the beginning of the document ║ ║ End Go to the bottom of the document ║ ║ PgUp Page up ║ ║ ║ ║ Any other key moves acts like PgDn (page down) ║ ║ ║ ║ Press any key to continue... ║ ╚══════════════════════════════════════════════════════════════════════════╝ DAYO GL, TJS LAB Page: 127 ■ DATABASE STRUCTURE Database: GL.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 GL_ENTRY Character 12 1 12 2 NAME Character 30 13 42 3 PERIOD1 Numeric 10 2 43 52 4 PERIOD2 Numeric 10 2 53 62 5 PERIOD3 Numeric 10 2 63 72 6 PERIOD4 Numeric 10 2 73 82 7 PERIOD5 Numeric 10 2 83 92 8 PERIOD6 Numeric 10 2 93 102 9 PERIOD7 Numeric 10 2 103 112 10 PERIOD8 Numeric 10 2 113 122 11 PERIOD9 Numeric 10 2 123 132 12 PERIOD10 Numeric 10 2 133 142 13 PERIOD11 Numeric 10 2 143 152 14 PERIOD12 Numeric 10 2 153 162 15 PERIOD13 Numeric 10 2 163 172 16 RETAINED Numeric 10 2 173 182 17 RETAIN Logical 1 183 183 18 BUDGET1 Numeric 10 2 184 193 19 BUDGET2 Numeric 10 2 194 203 20 BUDGET3 Numeric 10 2 204 213 21 BUDGET4 Numeric 10 2 214 223 22 BUDGET5 Numeric 10 2 224 233 23 BUDGET6 Numeric 10 2 234 243 24 BUDGET7 Numeric 10 2 244 253 25 BUDGET8 Numeric 10 2 254 263 26 BUDGET9 Numeric 10 2 264 273 27 BUDGET10 Numeric 10 2 274 283 28 BUDGET11 Numeric 10 2 284 293 29 BUDGET12 Numeric 10 2 294 303 30 BUDGET13 Numeric 10 2 304 313 31 DR Character 1 314 314 32 CR Character 1 315 315 33 DATE Date 8 316 323 34 LASTDATE Date 8 324 331 ────────── ───── Total 332 DAYO GL, TJS LAB Page: 128 Database: GLTRANS.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 TRANSACT Character 12 1 12 2 CLASS Character 3 13 15 3 NAME Character 30 16 45 4 DEBIT Character 12 46 57 5 CREDIT Character 12 58 69 6 AMOUNT Numeric 10 2 70 79 7 DATE Date 8 80 87 ────────── ───── Total 88 Database: GLCLASS.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 CLASS Character 3 1 3 2 NAME Character 30 4 33 3 DEBIT Character 12 34 45 4 CREDIT Character 12 46 57 5 DATABASE Character 12 58 69 6 FIELD Character 30 70 99 7 GL_FILTER Character 40 100 139 8 GL_LOGICAL Character 12 140 151 9 DATE Date 8 152 159 ────────── ───── Total 160 Database: GLPERIOD.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 PERIOD Character 30 1 30 2 FROM_DATE Date 8 31 38 3 TO_DATE Date 8 39 46 ────────── ───── Total 47 DAYO GL, TJS LAB Page: 129 Database: GLTABLED.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 GLTAB Numeric 6 1 6 2 SIGN Character 1 7 7 3 GL_ENTRY Character 12 8 19 4 DATE Date 8 20 27 ────────── ───── Total 28 Database: GLTABLEH.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 GLTAB Numeric 6 0 1 6 2 NAME Character 30 7 36 3 DATE Date 8 37 44 ────────── ───── Total 45 Database: GLDEPT.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 NAME Character 30 1 30 2 GLCODE Character 10 31 40 3 DATE Date 8 41 48 ────────── ───── Total 49 Database: GLHIST.DBF Field Field name Type Width Dec Start End ───── ────────── ───────── ───── ─── ───── ─── 1 TRANSACT Character 12 1 12 2 CLASS Character 3 13 15 3 NAME Character 30 16 45 4 DEBIT Character 12 46 57 5 CREDIT Character 12 58 69 6 AMOUNT Numeric 10 2 70 79 7 DATE Date 8 80 87 ────────── ───── Total 88 DAYO GL, TJS LAB Page: 130 ■ DATA DICTIONARY Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── AMOUNT N 10 2 GLHIST.DBF Amount of transactions GLTRANS.DBF BUDGET1 N 10 2 GL.DBF Budget amount for period 1 BUDGET10 N 10 2 GL.DBF Budget amount for period 10 BUDGET11 N 10 2 GL.DBF Budget amount for period 11 BUDGET12 N 10 2 GL.DBF Budget amount for period 12 BUDGET13 N 10 2 GL.DBF Budget amount for period 13 BUDGET2 N 10 2 GL.DBF Budget amount for period 2 BUDGET3 N 10 2 GL.DBF Budget amount for period 3 BUDGET4 N 10 2 GL.DBF Budget amount for period 4 BUDGET5 N 10 2 GL.DBF Budget amount for period 5 BUDGET6 N 10 2 GL.DBF Budget amount for period 6 BUDGET7 N 10 2 GL.DBF Budget amount for period 7 BUDGET8 N 10 2 GL.DBF Budget amount for period 8 BUDGET9 N 10 2 GL.DBF Budget amount for period 9 CLASS C 3 0 GLCLASS.DBF Class Code GLHIST.DBF GLTRANS.DBF CR C 1 0 GL.DBF Credit flag + or - CREDIT C 12 0 GLCLASS.DBF GL Credit Account Number GLHIST.DBF GLTRANS.DBF DATABASE C 12 0 GLCLASS.DBF Database Name that the Class Code uses to post transactions from DATE D 8 0 GLTRANS.DBF Date of record was created GLCLASS.DBF GLHIST.DBF GL.DBF GLTABLEH.DBF GLTABLED.DBF GLDEPT.DBF DEBIT C 12 0 GLTRANS.DBF GL Debit Account Number GLHIST.DBF GLCLASS.DBF DR C 1 0 GL.DBF Debit flag + or - FIELD C 30 0 GLCLASS.DBF Field Expression, ie: AMOUNT or COST QTY FROM_DATE D 8 0 GLPERIOD.DBF Start date for an Accounting period GLCODE C 10 0 GLDEPT.DBF Department Code GL_ENTRY C 12 0 GL.DBF GL Account Number GL_FILTER C 40 0 GLCLASS.DBF GL Filter. Optional conditional value used in the posting of GL transactions GL_LOGICAL C 12 0 GLCLASS.DBF Not Used GLTAB N 6 0 GLTABLEH.DBF SUBTOTAL control number, used GLTABLED.DBF with the Financial Statement DAYO GL, TJS LAB Page: 131 ■ DATA DICTIONARY Continued... Field Name Type Len Dec Database Description/Comments ────────── ──── ─── ─── ──────────── ────────────────────────────────── LASTDATE D 8 0 GL.DBF Date last accessed/posted to NAME C 30 0 GLHIST.DBF Name of the transaction GLTRANS.DBF " " " " GLCLASS.DBF Name of the Class Code GL.DBF Name of the GL Account Number GLTABLEH.DBF Name of the SUBTOTAL GLDEPT.DBF Department Name PERIOD C 30 0 GLPERIOD.DBF Name of the Accounting Period PERIOD1 N 10 2 GL.DBF Balance for period 1 PERIOD10 N 10 2 GL.DBF Balance for period 10 PERIOD11 N 10 2 GL.DBF Balance for period 11 PERIOD12 N 10 2 GL.DBF Balance for period 12 PERIOD13 N 10 2 GL.DBF Balance for period 13 PERIOD2 N 10 2 GL.DBF Balance for period 2 PERIOD3 N 10 2 GL.DBF Balance for period 3 PERIOD4 N 10 2 GL.DBF Balance for period 4 PERIOD5 N 10 2 GL.DBF Balance for period 5 PERIOD6 N 10 2 GL.DBF Balance for period 6 PERIOD7 N 10 2 GL.DBF Balance for period 7 PERIOD8 N 10 2 GL.DBF Balance for period 8 PERIOD9 N 10 2 GL.DBF Balance for period 9 RETAINED N 10 2 GL.DBF Retained balance from last year RETAIN L 1 0 GL.DBF Flag to retail balances at Year End Roll SIGN C 1 0 GLTABLED.DBF Sign determines if the value of the GL entry will be added or subtracted from the SUBTOTAL. Used in the Financial Statement TO_DATE D 8 0 GLPERIOD.DBF Ending date for an Accounting period TRANSACT C 12 0 GLHIST.DBF Transaction number GLTRANS.DBF DAYO GL, TJS LAB Page: 132 ■ DAYO GL MAINTENANCE & QUIRKS - If you are on a multiuser network, you must 'flag' (change file attributes) of all files to make them sharable, readable and writable. Note that the command/program 'flag' may be called by a different name on your network. ie: E:\>FLAG *.NTX SRW or just to be safe, go ahead and flag all files in the DAYO directory: E:\>FLAG *.* SRW - Backups of your data and configuration files should take place daily! You have no doubt heard many 'scare' stories about losing data. They are all true! The key files that need to be backed up all have the extension of .DBF, .DBT, and .CFG. The .DBF files are your databases. The .DBT files are notes/memos. The .CFG file(s) contain your configuration information (as seen in the Configuration module). - If you are on a network, it is NOT recommended that you use dBase III+ with the databases. It may write an end of file marker not always recognized by DAYO. Appending additional records to the database after this point often leads/creates a 'bad record' in the database. - If you must use dBase (tm) with DAYO GL, and you are on a PC based network/LAN, be sure to SET EXCLUSIVE OFF before you open ANY databases. This will allow the opened databases to be shared, and more importantly, prevent a user (or all users!) from 'crashing'! - If the SIMPLE EDITOR tends to 'hang' your CPU, even on small files, then do not use it... Hope to fix this 'feature' with the next upgrade... DAYO GL, TJS LAB Page: 133 ■ TJS 'Computer' LAB TJS LAB is an association of programmers and technicians that produce customized, multiuser software for the PC based network (ie: Novell and others). Our specialties include Inventory Control, PC Communications/EDI, Management, Reports (standard and graphic), Data Conversions, and Accounting (A/R, A/P). A unique feature of TJS LAB is that our software is by default, multiuser. 'Standalone' applications are the exception! All our applications are written in Clipper, Basic, or C (preferably Basic or Clipper). We will license all our application source codes. We produce applications that work, are easy to use, and are inexpensive! Want a change? Want an enhancement! Want a completely new product/application? Want to make your idea a reality? Custom/contract programming, by TJS LAB, and our associates is available. Standard rate is $35.00 per hour (our sites). Guaranteed quality and timely work is our number one policy. We make program enhancements/changes/fixes at our location(s), but can/do make 'house calls' via special software and a modem. Write us at: TJS LAB PO Box 585366 Orlando, Florida 32858-5366 Or call us (8:00 am - 11:00 pm): (407) 291-3960 * Note that TJS LAB, nor any of the associates accept/take any support calls for unregistered Shareware products. TJS LAB, Computer Division In an effort to provide the 'total solution', TJS LAB now offers personal computer systems, printers, software and accessories at a much discounted price. All equipment is warranted by the manufacturer for at least one year. Call or write us for more information...